On this page

    SYS.PRIVILEGES

    The sys.privileges table contains metadata for privileges for objects in the Dremio instance.

    Syntax
    SELECT * 
    FROM sys.privileges
    

    Example Output

    grantee_idgrantee_typeprivilegeobject_idobject_type
    test_useruserALTER“@test_user”.“nyc_taxi”PDS
    test_useruserSELECT“@test_user”.“nyc_taxi”PDS
    test_useruserSELECT“@test_user”.remove_spacesFUNCTION
    test_roleroleSELECT“reporting”.“nyc_taxi_2022”VDS
    test_user2userALTER“reporting”.test FOLDER
    admin_useruserMODIFY“Samples”SOURCE
    admin_useruserCREATE_USERempty textSYSTEM
    test_user2userMANAGE_GRANTS2abbe93f-726b-4be6-81d5-f1ed6919a458SCRIPT
    test_user2userMODIFY20b8dbc6-0530-49a4-a2d4-6cc24d6663e9SCRIPT

    Fields

    FieldData TypeDescription
    grantee_idvarcharThe user or role name for 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 or UUID of the object on which the privilege has been granted.
    object_typevarcharThe type of the object on which the privilege has been granted.