SHOW PRIVILEGES
On this page
Displays a list of the supported system privileges.
Syntax
SHOW PRIVILEGES;
Remarks
-
See the Permission Matrix for the required permission.
Examples
SHOW PRIVILEGES;
+-------------------------+---------------------------------------+-------------------------------------------------------+
| Privilege | Context | Sum |
+-------------------------+---------------------------------------+-------------------------------------------------------+
| Alter | Tables | To alter the table |
| Alter routine | Functions,Procedures | To alter or drop stored functions/procedures |
| Alter view | Databases, Tables | To alter existing views |
| Backup | Databases | To execute backups |
| Cluster | Server Admin | To administer the cluster |
| Create | Databases,Tables,Indexes | To create new tables |
| Create database | Databases | To create databases |
| 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 |
| Drop | Databases,Tables | To drop tables |
| Drop database | Databases | To drop databases |
| Drop view | Databases, Tables | To drop views |
| Execute | Functions,Procedures | To execute stored routines |
| File read | Read-only file access on server | To read files on the server |
| File write | Write-only file access on server | To 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 |
| References | Databases,Tables | To have references on tables |
| Reload | Server Admin | To reload or refresh tables and logs |
| Replication client | Server Admin | To ask where the secondary or primary servers are |
| Replication secondary | Server Admin | To read binary log events from the primary |
| 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, etc. |
| Trigger | Tables | To use triggers |
| Create tablespace | Server Admin | To create/alter/drop tablespaces |
| Update | Tables | To update existing rows |
| Usage | Server Admin | No privileges - allow connect only |
+-------------------------+---------------------------------------+-------------------------------------------------------+
36 rows in set (0.00 sec)Last modified: June 23, 2023