Privileges for MariaDB Xpand 6.0

Overview

Privileges can be granted to users to control who can perform what actions in MariaDB Xpand.

Privilege

Description

ALL

Grants all available privileges at the gtiven privilege scope. Alias for ALL PRIVILEGES.

ALL PRIVILEGES

Grants all available privileges at the given privilege level. Granting all privileges on a table does not grant any privileges on a database, for example.

ALTER

Grants ability to ALTER TABLE

ALTER ROUTINE

Grants ability to ALTER FUNCTION, ALTER PROCEDURE, DROP FUNCTION, DROP PROCEDURE

CREATE

Grants ability to CREATE DATABASE, CREATE TABLE

CREATE ROUTINE

Grants ability to CREATE FUNCTION, CREATE PROCEDURE

CREATE TABLESPACE

Unused, but is checked in granting privileges to other users (such as GRANT ALL)

CREATE TEMPORARY TABLES

Grants ability to CREATE TEMPORARY TABLE

CREATE USER

Grants ability to CREATE USER, or to create user with GRANT

CREATE VIEW

Grants ability to CREATE VIEW

DELETE

Grants ability to DELETE

DROP

Grants ability to DROP DATABASE, DROP TABLE, DROP VIEW, TRUNCATE

EVENT

Unused, but is checked in granting privileges to other users (such as GRANT ALL)

EXECUTE

Grants ability to execute stored routines

FILE

Grants ability to Read and write files on the server

GRANT OPTION

Grants ability to GRANT (granting privileges only)

INDEX

Grants ability to CREATE INDEX, DROP INDEX, or create an index with ALTER TABLE

INSERT

Grants ability to INSERT

LOCK TABLES

Grants ability to LOCK TABLES (requires SELECT privilege)

OSAUTH

Grants the ability for the user to be authenticated by the OS. This allows a SQL user to log in without a password as long as they have been authenticated as the corresponding OS user.

PROCESS

Grants ability to SHOW PROCESSLIST

PROXY

Unused

REFERENCES

Creating a foreign key constraint requires the REFERENCES privilege for the parent table

RELOAD

Grants ability to FLUSH

REPLICATION CLIENT

Grants ability to SHOW MASTER STATUS, SHOW SLAVE STATUS, SHOW BINARY LOGS

REPLICATION REPLICA

Grants ability to read binary log events from the master (needed by replicas). Alias for REPLICATION SLAVE.

REPLICATION SLAVE

Grants ability to read binary log events from the master (needed by replicas)

SELECT

Grants ability to SELECT

SHOW DATABASES

Grants ability to SHOW DATABASES

SHOW GRANTS

SHOW VIEW

Grants ability to SHOW CREATE VIEW

SHUTDOWN

Grants ability to shut down the server

SUPER

Grants ability to perform superuser operations such as KILL thread, SET GLOBAL, CHANGE MASTER, etc.

TRIGGER

Grants ability to CREATE TRIGGER, DROP TRIGGER, execute triggers on tables you update

TRUNCATE

UPDATE

Grants ability to UPDATE (requires SELECT privilege for WHERE clause)

USAGE

Grants ability to connect to the database server

XPAND