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 | Summary |
+-------------------------+------------------------------------------+-------------------------------------------------------+
| Alter | Tables | To alter tables |
| 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 create stored functions/procedures |
| Create temporary tables | Databases | To create temporary tables |
| Create view | Tables | To create new views |
| Create user | Server Admin | To create new users |
| Delete | Tables | To delete 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 grant your privileges to other users |
| Index | Tables | To create or drop indexes |
| Insert | Tables | To insert data into tables |
| Lock tables | Databases | To use LOCK TABLES (with SELECT privilege) |
| Process | Server Admin | To view currently executing queries |
| References | Databases, Tables | To create foreign key references |
| Reload | Server Admin | To reload or refresh tables and logs |
| Replication client | Server Admin | To view replication source information |
| Replication secondary | Server Admin | To read binary log events from the primary |
| Select | Tables | To retrieve rows from tables |
| Show databases | Server Admin | To view all databases |
| Show plan | Server Admin | To view execution plans |
| Show view | Tables | To view definitions with SHOW CREATE VIEW |
| Super | Server Admin | To use KILL, SET GLOBAL, and similar commands |
| Trigger | Tables | To create and use triggers |
| Create tablespace | Server Admin | To create, alter, or drop tablespaces |
| Update | Tables | To update existing rows |
| Usage | Server Admin | No privileges (connect only) |
+-------------------------+------------------------------------------+-------------------------------------------------------+
36 rows in set (0.00 sec)Last modified: