数据湖探索 DLI-数据赋权(用户或项目):请求示例

时间:2024-05-16 16:52:58

请求示例

  • 赋予某项目(项目ID:0732e57c728025922f04c01273686950)数据库db1的查询权限、数据表db1.tbl的删除权限、数据表指定列db1.tbl.column1的查询权限。
    {
      "grant_project_id": "0732e57c728025922f04c01273686950",
      "action": "grant",
      "privileges": [
        {
          "object": "databases.db1.tables.tb2.columns.column1",
          "privileges": ["SELECT"]
         },
        {
          "object": "databases.db1.tables.tbl",
          "privileges": ["DROP_TABLE"]
        },
       {
       "object": "databases.db1",
       "privileges": ["SELECT"]
       }
     ]
    }
  • 赋予某用户dlitest的数据库dbtest的查询数据权限。
    {
        "action": "grant",
        "privileges": [
            {
                "object": "databases.dbtest",
                "privileges": [
                    "SELECT"
                ]
            }
        ],
        "user_name": "dlitest"
    }
support.huaweicloud.com/api-dli/dli_02_0318.html