On this page

    SYS.ORGANIZATION.ROLES

    The sys.organization.roles table contains metadata for roles in an organization.

    Syntax
    SELECT * 
    FROM sys.organization.roles
    

    Example Output

    role_idrole_namerole_typeowner_idowner_type
    3d0188ad-c79a-4339-90e1-8f53f2021065PUBLICSYSTEMempty textempty text
    700e5ad4-4c37-44d1-99bf-9bbadf998ceeUSERADMINSYSTEMempty textempty text
    95242298-a1da-4a10-bd8e-27260685c0a5ADMINSYSTEMempty textempty text
    ffe21b2e-2f54-4788-b808-78fbddec36a8DEVADMININTERNAL80000000-37c5-454c-93f2-ec44ea4444edUSER

    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:
    SYSTEM: A predefined role created by Dremio.
    INTERNAL: A role created by the user in 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.
    owner_typevarcharThe type of owner of the role.
    Enum: USER, ROLE