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: USERROLE |
| 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 |