Skip to main content

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.

Syntax
SELECT * 
FROM sys.organization.privileges

Example Output

note

For object_type, PDS indicates a table and VDS indicates a view.

grantee_idgrantee_typeprivilegeobject_idobject_type
test.user@dremio.comuserALTER@test.user@dremio.com.weatherVDS
test.user@dremio.comuserSELECT@test.user@dremio.com.weatherVDS
PUBLICroleENGINEfirstEngineUSAGE
PUBLICroleENGINEpreviewUSAGE
test.user@dremio.comuserOWNERSHIPacme corporation orgORG
test.user2@dremio.comuserOWNERSHIPreflections-engineENGINE
test.user@dremio.comuserOWNERSHIPdefault-cloudCLOUD
test.user@dremio.comuserOWNERSHIPdev-projectPROJECT

Fields

FieldData TypeDescription
grantee_idvarcharThe user or role to which the object has been granted.
grantee_typevarcharThe type of object that the privilege is granted to.
Enum: user, role
privilegevarcharThe privilege granted on the object to the grantee.
object_idvarcharThe name of the object on which the privilege has been granted.
object_typevarcharThe type of the object on which the privilege has been granted.