更新时间:2026-10-09 GMT+08:00
分享

显示所有权限

语法格式

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;

相关文档