Skip to main content
Version: 24.3.x

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