Privileges for MariaDB Xpand 5.3

This page is part of MariaDB's Documentation.

The parent of this page is: Reference for MariaDB Xpand 5.3

Topics on this page:

Overview

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