数据仓库服务 GAUSSDB(DWS)-如何给指定用户赋予某张表的权限?:语法格式

时间:2024-04-30 17:23:47

语法格式

1
2
3
4
5
6
GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER | ANALYZE | ANALYSE } [, ...] 
      | ALL [ PRIVILEGES ] }
    ON { [ TABLE ] table_name [, ...]
       | ALL TABLES IN SCHEMA schema_name [, ...] }
    TO { [ GROUP ] role_name | PUBLIC } [, ...] 
    [ WITH GRANT OPTION ];
support.huaweicloud.com/dws_faq/dws_03_0197.html