On this page

    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

    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.