Privileges for MariaDB Xpand 5.3

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 given privilege scope. Alias for ALL PRIVILEGES.

ALL PRIVILEGES

Grants all available privileges at the given privilege scope

ALTER

Grants ability to execute ALTER TABLE

ALTER ROUTINE

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

CREATE

Grants ability to execute CREATE DATABASE and CREATE TABLE

CREATE ROUTINE

Grants ability to execute CREATE FUNCTION and CREATE PROCEDURE

CREATE TABLESPACE

Tablespaces are unsupported. This privilege is primarily for compatibility.

CREATE TEMPORARY TABLES

Grants ability to execute CREATE TEMPORARY TABLE

CREATE USER

Grants ability to execute CREATE USER, DROP USER, and to use GRANT to create or drop a user

CREATE VIEW

Grants ability to execute CREATE VIEW

DELETE

Grants ability to execute DELETE

DROP

Grants ability to execute DROP DATABASE, DROP TABLE, and DROP VIEW

EVENT

Events are unsupported. This privilege is primarily for compatibility.

EXECUTE

Grants ability to execute stored routines

FILE

This privilege is primarily for compatibility

GRANT OPTION

Grants ability to execute GRANT

INDEX

Grants ability to execute CREATE INDEX, DROP INDEX, and to use ALTER TABLE to create or drop an index

INSERT

Grants ability to execute INSERT

LOCK TABLES

Grants ability to execute LOCK TABLES

OSAUTH

Grants the ability for the user to be authenticated by the OS

PROCESS

Grants ability to execute SHOW PROCESSLIST and SHOW ENGINES

PROXY

Proxy users are unsupported. This privilege is primarily for compatibility.

REFERENCES

This privilege is primarily for compatibility

RELOAD

Grants ability to execute FLUSH

REPLICATION CLIENT

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

REPLICATION SLAVE

Grants ability to read binary log events for replication or point-in-time restoration (PITR)

SELECT

Grants ability to execute SELECT

SHOW DATABASES

Grants ability to execute SHOW DATABASES

SHOW GRANTS

Grants ability to execute SHOW GRANTS

SHOW VIEW

Grants ability to execute SHOW CREATE VIEW

SHUTDOWN

Grants ability to shut down the server by executing SHUTDOWN, but MariaDB recommends using "clx dbstop" instead

SUPER

Grants ability to perform superuser operations, such as KILL, SET GLOBAL, and others

TRIGGER

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

TRUNCATE

Grants the ability to execute TRUNCATE

UPDATE

Grants ability to execute UPDATE

USAGE

Grants ability to connect to the database server

XPAND

Internal use