SYS.ORGANIZATION.PRIVILEGES
The sys.organization.privileges table contains metadata for privileges at the organization-level. To access project-level privileges, see the sys.project.privileges table.
SELECT *
FROM sys.organization.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@dremio.com | user | ALTER | @test.user@dremio.com.weather | VDS |
| test.user@dremio.com | user | SELECT | @test.user@dremio.com.weather | VDS |
| PUBLIC | role | ENGINE | firstEngine | USAGE |
| PUBLIC | role | ENGINE | preview | USAGE |
| test.user@dremio.com | user | OWNERSHIP | acme corporation org | ORG |
| test.user2@dremio.com | user | OWNERSHIP | reflections-engine | ENGINE |
| test.user@dremio.com | user | OWNERSHIP | default-cloud | CLOUD |
| test.user@dremio.com | user | OWNERSHIP | dev-project | PROJECT |
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. |