On this page

    Get List of Privileges

    Note:
    Version Requirement:

    This functionality is for Dremio v18.0+ Enterprise Edition only.

    This API returns a list of privileges associated with the role, up to a maximum of 100.

    Endpoint Syntax

    Method and URL
    GET /api/v3/role/{id}/privilege
    

    Required Privileges

    All users executing this Rest API must have the MANAGE GRANTS privilege assigned to receive a response output.

    Response Output

    This is the standard response output for the API.

    Response output
    {"data": [
      {
       "name": "src1.folder1.db1",
       "type": "dataset",
       "privilege": "SELECT"
      },
        …
      ]
     }
    

    Response Codes

    • 204 - Successful if all operations are successful.
    • 400 - The request is bad. Either the role ID does not exist or an operation failed.
    • 403 - The user executing the API request lacks the MANAGE GRANTS permission.
    • 404 - The role is not found.

    Example

    Example response
    curl -X GET --location "http://localhost:9047/api/v3/role/5ebcf4fa-ef8d-4bb4-8660-b18b18f661d6/privileges" \
        -H "Authorization: _dremiohrr395nv31g8k610616tucp91g" \
        -H "Content-Type: application/json" \
        -H "Accept: application/json"