Get Privileges

Version Requirement:

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

This API returns a list of privileges associated with the user, up to a total of 100 privileges.

Endpoint Syntax

GET /api/v3/user/{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.

{“data”: [
   “name”: “src1.folder1.db1”,
   “type”: “dataset”,
   “privilege”: “SELECT”

Response Codes

  • 200 - Success.
  • 403 - The user executing the API request lacks the MANAGE GRANTS permission.
  • 404 - The user is not found.


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