SYS.ROLES
The sys.roles table contains metadata for roles in the Dremio instance.
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$ | empty text | LOCAL |
| 700e5ad4-4c37-44d1-99bf-9bbadf998cee | USERADMIN | LOCAL | empty text | empty text | LOCAL |
| 95242298-a1da-4a10-bd8e-27260685c0a5 | ADMIN | LOCAL | $dremio$ | empty text | LOCAL |
| ffe21b2e-2f54-4788-b808-78fbddec36a8 | DEVADMIN | EXTERNAL | 80000000-37c5-454c-93f2-ec44ea4444ed | USER | LOCAL |
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. Enum: LOCAL: A role created within Dremio.EXTERNAL: A role that was not created within Dremio. |
| 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. Enum: USER, ROLE |
| created_by | varchar | The method of creation. Enum: LOCAL, AUTO_SYNC, SCIM |