User privileges

The privileges or rights that we can grant to users are many and varied. They break down into three main categories:

• Global administrative user privileges

• Database, table, and column user privileges

• Miscellaneous user privileges and limits

when you look through the following tables of privileges, don't worry if you do not understand every privilege and what it means. For now, it's enough to just be aware of them and of the fact that privileges are how MariaDB controls what a user can do.

Global administrative user privileges

The following table lists the global administrative user privileges. Global privileges apply to all databases, and tables within those databases, which belong to an entire MariaDB database server or server cluster:

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...