SHOW PRIVILEGES
更新时间：2025-10-16
描述
SHOW PRIVILEGES 语句用于显示数据库系统中当前可用的权限列表。它帮助用户了解系统支持的权限类型以及每种权限的详细信息。
语法
SQL
1SHOW PRIVILEGES返回值
| 列名 | 说明 |
|---|---|
| Privilege | 权限名 |
| Context | 可作用范围 |
| Comment | 说明 |
权限控制
执行此 SQL 命令的用户不需要具有特定的权限。
示例
查看所有权限项
SQL
1SHOW PRIVILEGES
Text
1+-------------+-------------------------------------------------------+-----------------------------------------------+
2| Privilege | Context | Comment |
3+-------------+-------------------------------------------------------+-----------------------------------------------+
4| Node_priv | GLOBAL | Privilege for cluster node operations |
5| Admin_priv | GLOBAL | Privilege for admin user |
6| Grant_priv | GLOBAL,CATALOG,DATABASE,TABLE,RESOURCE,WORKLOAD GROUP | Privilege for granting privilege |
7| Select_priv | GLOBAL,CATALOG,DATABASE,TABLE | Privilege for select data in tables |
8| Load_priv | GLOBAL,CATALOG,DATABASE,TABLE | Privilege for loading data into tables |
9| Alter_priv | GLOBAL,CATALOG,DATABASE,TABLE | Privilege for alter database or table |
10| Create_priv | GLOBAL,CATALOG,DATABASE,TABLE | Privilege for creating database or table |
11| Drop_priv | GLOBAL,CATALOG,DATABASE,TABLE | Privilege for dropping database or table |
12| Usage_priv | RESOURCE,WORKLOAD GROUP | Privilege for using resource or workloadGroup |
13+-------------+-------------------------------------------------------+-----------------------------------------------+