文档首页/ 智能数据湖 AI DataLake/ Spark语法参考/ 数据集/ 数据集权限/ 授予用户访问权限
更新时间：2026-10-09 GMT+08:00
查看PDF
分享

授予用户访问权限

语法格式

GRANT <privilege>* ON <resource>* TO <principal>*
  • privilege：要授予主体对资源的权限
  • resource：授予权限的实体
  • principal：授予权限的用户/角色

代码示例

读/写/全部（读+写）- Dataset级别授权：
GRANT READ_DATASET ON databases.demo_db1.datasets.demo_ds1 TO USER aid_developer03;
GRANT WRITE_DATASET ON databases.demo_db1.datasets.demo_ds1 TO USER aid_developer03;
GRANT ALL ON databases.demo_db1.datasets.demo_ds1 TO USER aid_developer03; 
GRANT READ_DATASET ON databases.demo_db1.datasets.demo_ds1 TO ROLE nit_role3;
GRANT WRITE_DATASET ON databases.demo_db1.datasets.demo_ds1 TO ROLE nit_role3;
GRANT ALL ON databases.demo_db1.datasets.demo_ds1 TO ROLE nit_role3; 

创建/列出 - Database级别授权： 
GRANT CREATE_DATASET ON databases.demo_db1 TO USER aid_developer03;
GRANT LIST_DATASET ON databases.demo_db1 TO USER aid_developer03; 
GRANT CREATE_DATASET ON databases.demo_db1 TO ROLE nit_role3;
GRANT LIST_DATASET ON databases.demo_db1 TO ROLE nit_role3

父主题： 数据集权限

相关文档