On this page

    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

    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.