# SHOW PRIVILEGES

Displays a list of the supported system privileges.

## Syntax

```sql
SHOW PRIVILEGES;
```

## Remarks

* See the [Permission Matrix](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/permissions-matrix.md) for the required permission.

## Examples

```sql
SHOW PRIVILEGES;

```

```output

+-------------------------+------------------------------------------+-------------------------------------------------------+
| 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)
```

***

Modified at: July 10, 2026

Source: [/db/v9.1/reference/sql-reference/show-commands/show-privileges/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-privileges/)

(An index of the documentation is available at /llms.txt)