Dremio Cloud
Dremio Software
 
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_id grantee_type privilege object_id object_type
    test_user user ALTER “@test_user”.“nyc_taxi” PDS
    test_user user SELECT “@test_user”.“nyc_taxi” PDS
    test_user user SELECT “@test_user”.remove_spaces FUNCTION
    test_role role SELECT “reporting”.“nyc_taxi_2022” VDS
    test_user2 user ALTER “reporting”.test FOLDER
    admin_user user MODIFY “Samples” SOURCE
    admin_user user CREATE_USER empty text SYSTEM
    test_user2 user MANAGE_GRANTS 2abbe93f-726b-4be6-81d5-f1ed6919a458 SCRIPT
    test_user2 user MODIFY 20b8dbc6-0530-49a4-a2d4-6cc24d6663e9 SCRIPT

    Fields

    Field Data Type Description
    grantee_id varchar The user or role name for 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 or UUID 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.