Dremio Cloud
Dremio Software
 
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_id role_name role_type owner_id owner_type created_by
    3d0188ad-c79a-4339-90e1-8f53f2021065 PUBLIC LOCAL $dremio$ empty text LOCAL
    700e5ad4-4c37-44d1-99bf-9bbadf998cee USERADMIN LOCAL empty text empty text LOCAL
    95242298-a1da-4a10-bd8e-27260685c0a5 ADMIN LOCAL $dremio$ empty text LOCAL
    ffe21b2e-2f54-4788-b808-78fbddec36a8 DEVADMIN EXTERNAL 80000000-37c5-454c-93f2-ec44ea4444ed USER LOCAL

    Fields

    Field Data Type Description
    role_id varchar The UUID to identify the role.
    role_name varchar The user- or system-defined name of the role.
    role_type varchar The role type.
    Enum:
    LOCAL: A role created within Dremio.
    EXTERNAL: A role that was not created within Dremio.
    owner_id varchar The 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_type varchar The type of owner of the role.
    Enum: USER, ROLE
    created_by varchar The method of creation.
    Enum: LOCAL, AUTO_SYNC, SCIM