数据仓库服务 GaussDB(DWS)-修改数据库对象权限:请求示例

时间:2023-11-01 16:20:35

请求示例

修改集群ID为“a89aea88-7ea2-40bd-8ac8-8b93e169e5d6”的数据库对象权限,即对gaussdb数据库下表table1和table2进行“SELECT”授权,授权角色为user1和user2,模式为public:

POST https://{Endpoint}/v1/0536cdee2200d5912f7cc00b877980f1/clusters/a89aea88-7ea2-40bd-8ac8-8b93e169e5d6/db-manager/authority{  "type" : "table",  "is_grant" : true,  "grant_list" : [ {    "permission" : "SELECT",    "grant_with" : true  } ],  "role_list" : [ "user1", "user2" ],  "object_list" : [ "table1", "table2" ],  "database" : "gaussdb",  "schema" : "public"}
support.huaweicloud.com/api-dws/dws_02_0705.html