Skip to main content

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_typecreated_by
3d0188ad-c79a-4339-90e1-8f53f2021065PUBLICSYSTEMempty textempty textLOCAL
700e5ad4-4c37-44d1-99bf-9bbadf998ceeUSERADMINSYSTEMempty textempty textLOCAL
95242298-a1da-4a10-bd8e-27260685c0a5ADMINSYSTEMempty textempty textLOCAL
ffe21b2e-2f54-4788-b808-78fbddec36a8DEVADMININTERNAL80000000-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:
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
created_byvarcharThe method of creation.
Enum: LOCAL, SCIM