Skip to main content
Version: current

Role Privileges Enterprise

Use the Role API to retrieve information about the privileges assigned to roles.

Role Privileges Object
{
  "data": [
    {
      "name": "hive",
      "type": "SOURCE",
      "privilege": "SELECT"
    },
    {
      "name": "hive",
      "type": "SOURCE",
      "privilege": "CREATE_TABLE"
    },
    {
      "name": "hive",
      "type": "SOURCE",
      "privilege": "INSERT"
    },
    {
      "name": "hive",
      "type": "SOURCE",
      "privilege": "DROP"
    },
    {
      "name": "hive",
      "type": "SOURCE",
      "privilege": "ALTER"
    },
    {
      "name": "mysql",
      "type": "SOURCE",
      "privilege": "EXTERNAL_QUERY"
    },
    {
      "name": "Samples",
      "type": "SOURCE",
      "privilege": "SELECT"
    },
    {
      "name": "Samples.\"samples.dremio.com\"",
      "type": "FOLDER",
      "privilege": "SELECT"
    },
    {
      "name": "Samples.\"samples.dremio.com\".\"SF_incidents2016.json\"",
      "type": "DATASET",
      "privilege": "SELECT"
    },
    {
      "name": "testing",
      "type": "SPACE",
      "privilege": "SELECT"
    }
  ]
}

Role Privileges Attributes​

{{< api-section file="data/software-api/role.json" data="rolePrivilegeAttributes" >}}

data​

{{< api-section file="data/software-api/role.json" data="dataPrivilegeAttributes" >}}

Retrieving Role Privileges​

Retrieve the specified role's privileges.

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

Parameters​

{{< api-section file="data/software-api/role.json" data="retrieveRolePrivilegesParameters" >}}


Example Request
curl -X GET 'https://{DREMIO_ORIGIN}/api/v3/role/3d83e7d7-98ee-4afa-ebdd-41c30eb92744/privilege' \
--header 'Authorization: _dremio{tokenstring}' \
--header 'Content-Type: application/json'
Example Response
{
  "data": [
    {
      "name": "hive",
      "type": "SOURCE",
      "privilege": "SELECT"
    },
    {
      "name": "hive",
      "type": "SOURCE",
      "privilege": "CREATE_TABLE"
    },
    {
      "name": "hive",
      "type": "SOURCE",
      "privilege": "INSERT"
    },
    {
      "name": "hive",
      "type": "SOURCE",
      "privilege": "DROP"
    },
    {
      "name": "hive",
      "type": "SOURCE",
      "privilege": "ALTER"
    },
    {
      "name": "mysql",
      "type": "SOURCE",
      "privilege": "EXTERNAL_QUERY"
    },
    {
      "name": "Samples",
      "type": "SOURCE",
      "privilege": "SELECT"
    },
    {
      "name": "Samples.\"samples.dremio.com\"",
      "type": "FOLDER",
      "privilege": "SELECT"
    },
    {
      "name": "Samples.\"samples.dremio.com\".\"SF_incidents2016.json\"",
      "type": "DATASET",
      "privilege": "SELECT"
    },
    {
      "name": "testing",
      "type": "SPACE",
      "privilege": "SELECT"
    }
  ]
}

Response Status Codes​

{{< api-responses file="data/software-api/role.json" data="retrieveRolePrivilegesResponses" >}}