Important
The SingleStore 9.1 release candidate (RC) gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 9.0 is recommended for production workloads, which can later be upgraded to SingleStore 9.1.
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: