SHOW PRIVILEGES
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
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