SYS.PROJECT.PRIVILEGES
The sys.project.privileges table contains metadata for privileges at the project-level. To access organization-level privileges, see the sys.organization.privileges table.
SELECT *
FROM sys.project.privileges
Example Output
note
For object_type, VDS indicates a view.
| grantee_id | grantee_type | privilege | object_id | object_type |
|---|---|---|---|---|
| test.user@dremio.com | user | ALTER | "@test.user@dremio.com".catalog_sales | VDS |
| test.user@dremio.com | user | SELECT | "@test.user@dremio.com".catalog_sales | VDS |
| test.user@dremio.com | user | ALTER | "@test.user@dremio.com"."SF Incidents" | VDS |
| test.user@dremio.com | user | SELECT | "@test.user@dremio.com"."SF Incidents" | VDS |
Fields
| Field | Data Type | Description |
|---|---|---|
| grantee_id | varchar | The user or role to 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 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. |