SYS.ROLES
The sys.roles
table contains role metadata.
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$ | user | LOCAL |
700e5ad4-4c37-44d1-99bf-9bbadf998cee | USERADMIN | LOCAL | 01329e94-afab-4393-b101-345fe68814b8 | role | LOCAL |
95242298-a1da-4a10-bd8e-27260685c0a5 | ADMIN | LOCAL | $dremio$ | user | LOCAL |
ffe21b2e-2f54-4788-b808-78fbddec36a8 | DEVADMIN | EXTERNAL | $dremio$ | user | SCIM |
01cc4941-9003-4452-be6d-3bc39dae1e78 | TESTER | EXTERNAL | $dremio$ | user | AUTO_SYNC |
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 Valid values: LOCAL : A role created and managed within DremioEXTERNAL : A role created and managed by an external authentication service like Okta or Microsoft Entra ID |
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. Valid values: USER ROLE |
created_by | varchar | The method of creation Valid values: LOCAL : All LOCAL role_types AUTO_SYNC : An EXTERNAL role created in Dremio with the role name from an external provider or referenced in Dremio in a privilege grantSCIM : An EXTERNAL role pushed to Dremio via SCIM |