On this page

    SYS.ROLES

    The sys.roles table contains metadata for roles in the Dremio instance.

    Syntax
    SELECT * 
    FROM sys.roles
    

    Example Output

    role_idrole_namerole_typeowner_idowner_typecreated_by
    3d0188ad-c79a-4339-90e1-8f53f2021065PUBLICLOCAL$dremio$empty textLOCAL
    700e5ad4-4c37-44d1-99bf-9bbadf998ceeUSERADMINLOCALempty textempty textLOCAL
    95242298-a1da-4a10-bd8e-27260685c0a5ADMINLOCAL$dremio$empty textLOCAL
    ffe21b2e-2f54-4788-b808-78fbddec36a8DEVADMINEXTERNAL80000000-37c5-454c-93f2-ec44ea4444edUSERLOCAL

    Fields

    FieldData TypeDescription
    role_idvarcharThe UUID to identify the role.
    role_namevarcharThe user- or system-defined name of the role.
    role_typevarcharThe role type.
    Enum:
    LOCAL: A role created within Dremio.
    EXTERNAL: A role that was not created within Dremio.
    owner_idvarcharThe UUID for the owner (user or role) of the role. This UUID corresponds to the id in the users or roles table. When there is no explicit owner set, the default is $dremio$.
    owner_typevarcharThe type of owner of the role.
    Enum: USER, ROLE
    created_byvarcharThe method of creation.
    Enum: LOCAL, AUTO_SYNC, SCIM