SYS.ORGANIZATION.ROLES
The sys.organization.roles table contains metadata for roles in an organization.
SELECT *
FROM sys.organization.roles
Example Output
| role_id | role_name | role_type | owner_id | owner_type | created_by |
|---|---|---|---|---|---|
| 3d0188ad-c79a-4339-90e1-8f53f2021065 | PUBLIC | SYSTEM | empty text | empty text | LOCAL |
| 700e5ad4-4c37-44d1-99bf-9bbadf998cee | USERADMIN | SYSTEM | empty text | empty text | LOCAL |
| 95242298-a1da-4a10-bd8e-27260685c0a5 | ADMIN | SYSTEM | empty text | empty text | LOCAL |
| ffe21b2e-2f54-4788-b808-78fbddec36a8 | DEVADMIN | INTERNAL | 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: SYSTEM: A predefined role created by Dremio.INTERNAL: A role created by the user in 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. |
| owner_type | varchar | The type of owner of the role. Enum: USER, ROLE |
| created_by | varchar | The method of creation. Enum: LOCAL, SCIM |