Dremio Cloud
Dremio Software
 
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_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.