SYS.PRIVILEGES
The sys.privileges table contains metadata for privileges for objects in the Dremio instance.
SELECT *
FROM sys.privileges
Example Output
note
For object_type, PDS indicates a table and VDS indicates a view.
| grantee_id | grantee_type | privilege | object_id | object_type |
|---|---|---|---|---|
| test_user | user | ALTER | "@test_user"."nyc_taxi" | PDS |
| test_user | user | SELECT | "@test_user"."nyc_taxi" | PDS |
| test_user | user | SELECT | "@test_user".remove_spaces | FUNCTION |
| test_role | role | SELECT | "reporting"."nyc_taxi_2022" | VDS |
| test_user2 | user | ALTER | "reporting".test | FOLDER |
| admin_user | user | MODIFY | "Samples" | SOURCE |
| admin_user | user | CREATE_USER | empty text | SYSTEM |
| test_user2 | user | MANAGE_GRANTS | 2abbe93f-726b-4be6-81d5-f1ed6919a458 | SCRIPT |
| test_user2 | user | MODIFY | 20b8dbc6-0530-49a4-a2d4-6cc24d6663e9 | SCRIPT |
Fields
| Field | Data Type | Description |
|---|---|---|
| grantee_id | varchar | The user or role name for which the object has been granted. |
| grantee_type | varchar | The type of object that the privilege is granted to. Enum: user, role |
| privilege | varchar | The privilege granted on the object to the grantee. |
| object_id | varchar | The name or UUID of the object on which the privilege has been granted. |
| object_type | varchar | The type of the object on which the privilege has been granted. |