Database Reference
In-Depth Information
Global administrative privileges
The following table lists the global administrative privileges. Global privileges
apply to all databases and tables within those databases, which belong to the entire
MariaDB database server.
Privilege
Description
CREATE USER
The ability to create a user using the
CREATE
USER
statement.
FILE
The ability to use the
LOAD DATA INFILE
statement and the
LOAD_FILE()
function.
PROCESS
The ability to use the
SHOW PROCESSLIST
command.
RELOAD
The ability to use the
FLUSH
statement.
REPLICATION CLIENT
The ability to use the
SHOW MASTER STATUS
and
SHOW SLAVE STATUS
commands.
REPLICATION SLAVE
The ability to get updates made on the
replication master server.
SHOW DATABASES
The ability to list all of the databases on the
server.
SHUTDOWN
The ability to shut down the server using the
mysqladmin shutdown
command.
SUPER
The ability to use superuser statements such
as
CHANGE MASTER TO...
,
PURGE LOGS
; to
SET
global variables; and to
KILL
other users'
threads.
Database, table, and column privileges
The following table lists the database and table privileges. These privileges only
apply to a specific database or table within a database.
Privilege
Description
ALTER
The ability to change indexes and tables.
ALTER ROUTINE
The ability to change or delete procedures
and stored functions.
CREATE
The ability to create databases and tables.
CREATE ROUTINE
The ability to create procedures and
stored functions.
CREATE TEMPORARY TABLES
The ability to crate temporary tables.
