MariaDB [(none)]> SHOW PRIVILEGES;
|
+--------------------------+---------------------------------------+--------------------------------------------------------------------+
|
| Privilege | Context | Comment |
|
+--------------------------+---------------------------------------+--------------------------------------------------------------------+
|
| Alter | Tables | To alter the table |
|
| Alter routine | Functions,Procedures | To alter or drop stored functions/procedures |
|
| Create | Databases,Tables,Indexes | To create new databases and tables |
|
| Create routine | Databases | To use CREATE FUNCTION/PROCEDURE |
|
| Create temporary tables | Databases | To use CREATE TEMPORARY TABLE |
|
| Create view | Tables | To create new views |
|
| Create user | Server Admin | To create new users |
|
| Delete | Tables | To delete existing rows |
|
| Delete history | Tables | To delete versioning table historical rows |
|
| Drop | Databases,Tables | To drop databases, tables, and views |
|
| Event | Server Admin | To create, alter, drop and execute events |
|
| Execute | Functions,Procedures | To execute stored routines |
|
| File | File access on server | To read and write files on the server |
|
| Grant option | Databases,Tables,Functions,Procedures | To give to other users those privileges you possess |
|
| Index | Tables | To create or drop indexes |
|
| Insert | Tables | To insert data into tables |
|
| Lock tables | Databases | To use LOCK TABLES (together with SELECT privilege) |
|
| Process | Server Admin | To view the plain text of currently executing queries |
|
| Proxy | Server Admin | To make proxy user possible |
|
| References | Databases,Tables | To have references on tables |
|
| Reload | Server Admin | To reload or refresh tables, logs and privileges |
|
| Binlog admin | Server | To purge binary logs |
|
| Binlog monitor | Server | To use SHOW BINLOG STATUS and SHOW BINARY LOG |
|
| Replication master admin | Server | To monitor connected slaves |
|
| Replication slave admin | Server | To start/monitor/stop slave and apply binlog events |
|
| Replication slave | Server Admin | To read binary log events from the master |
|
| Select | Tables | To retrieve rows from table |
|
| Show databases | Server Admin | To see all databases with SHOW DATABASES |
|
| Show view | Tables | To see views with SHOW CREATE VIEW |
|
| Shutdown | Server Admin | To shut down the server |
|
| Super | Server Admin | To use KILL thread, SET GLOBAL, CHANGE MASTER, etc. |
|
| Trigger | Tables | To use triggers |
|
| Create tablespace | Server Admin | To create/alter/drop tablespaces |
|
| Update | Tables | To update existing rows |
|
| Set user | Server | To create views and stored routines with a different definer |
|
| Federated admin | Server | To execute the CREATE SERVER, ALTER SERVER, DROP SERVER statements |
|
| Connection admin | Server | To bypass connection limits and kill other users' connections |
|
| Read_only admin | Server | To perform write operations even if @@read_only=ON |
|
| Usage | Server Admin | No privileges - allow connect only |
|
+--------------------------+---------------------------------------+--------------------------------------------------------------------+
|
39 rows in set (0.008 sec)
|