Skip to main content
Version: 0.0.1

Role Privileges {{< chip enterprise >}}

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

{{< codeheader "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.

{{< codeheader "Method and URL" >}}

GET /api/v3/role/{id}/privilege

Parameters​

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


{{< codeheader "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'

{{< codeheader "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" >}}