Privileges for MariaDB Enterprise Server 10.3
This page is part of MariaDB's Documentation.
The parent of this page is: Reference for MariaDB Enterprise Server 10.3
Topics on this page:
Overview
Privileges can be granted to users to control who can perform what actions in MariaDB Enterprise Server.
Privilege | Description |
---|---|
Grants ability to GRANT other users the roles you hold | |
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. | |
Grants ability to ALTER TABLE | |
Grants ability to ALTER FUNCTION, ALTER PROCEDURE | |
Grants ability to CREATE DATABASE, CREATE TABLE | |
Grants ability to CREATE FUNCTION, CREATE PROCEDURE | |
Unused, but is checked in granting privileges to other users (such as GRANT ALL) | |
Grants ability to CREATE TEMPORARY TABLE | |
Grants ability to CREATE USER, or to create user with GRANT | |
Grants ability to CREATE VIEW | |
Grants ability to DELETE | |
Grants ability to DELETE HISTORY (from a system-versioned table) | |
Grants ability to DROP DATABASE, DROP TABLE, DROP VIEW, TRUNCATE | |
Grants ability to ALTER EVENT, CREATE EVENT, DROP EVENT, and execute events | |
Grants ability to execute stored routines | |
Grants ability to Read and write files on the server | |
Grants ability to GRANT (granting privileges only) | |
Grants ability to CREATE INDEX, DROP INDEX, or create an index with ALTER TABLE | |
Grants ability to INSERT | |
Grants ability to LOCK TABLES (requires SELECT privilege) | |
Grants ability to SHOW PROCESSLIST | |
Grants ability to Proxy from one account to another | |
Unused, but is checked in granting privileges to other users (such as GRANT ALL) | |
Grants ability to FLUSH | |
Grants ability to SHOW MASTER STATUS, SHOW SLAVE STATUS, SHOW BINARY LOGS. In ES10.5, is an alias for BINLOG MONITOR and the capabilities have changed. BINLOG MONITOR grants ability to SHOW MASTER STATUS, SHOW BINARY LOGS, SHOW BINLOG EVENTS, and SHOW BINLOG STATUS. | |
Grants ability to read binary log events from the master (needed by replicas). Capabilities changed in ES10.5, see details. REPLICATION REPLICA was added as an alias in 10.5. | |
Grants ability to SELECT | |
Grants ability to SHOW DATABASES | |
Grants ability to SHOW SCHEMAS. SHOW SCHEMAS is a synonym for SHOW DATABASES. | |
Grants ability to SHOW CREATE VIEW | |
Grants ability to shut down the server | |
Grants ability to perform superuser operations such as KILL thread, SET GLOBAL, CHANGE MASTER, etc. | |
Grants ability to CREATE TRIGGER, DROP TRIGGER, execute triggers on tables you update | |
Grants ability to UPDATE (requires SELECT privilege for WHERE clause) | |
Grants ability to connect to the database server |