Skip to main content

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.

Syntax
SELECT * 
FROM sys.project.privileges

Example Output

note

For object_type, VDS indicates a view.

grantee_idgrantee_typeprivilegeobject_idobject_type
test.user@dremio.comuserALTER"@test.user@dremio.com".catalog_salesVDS
test.user@dremio.comuserSELECT"@test.user@dremio.com".catalog_salesVDS
test.user@dremio.comuserALTER"@test.user@dremio.com"."SF Incidents"VDS
test.user@dremio.comuserSELECT"@test.user@dremio.com"."SF Incidents"VDS

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.