# 显示所有权限
#### 语法格式
```
SHOW GRANT <principal>  ON <resource>
```
- **principal**：列出特定用户/角色的权限
- **resource**：列出特定实体的权限
#### 代码示例
```
SHOW GRANT USER aid_developer03 ON databases.demo_db1.datasets.demo_ds1;
SHOW GRANT ROLE nit_role3 ON databases.demo_db1.datasets.demo_ds1;
SHOW GRANT USER aid_developer03 ON databases.demo_db1;
SHOW GRANT ROLE nit_role3 ON databases.demo_db1;
```