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 |
---|---|---|---|---|
3d0188ad-c79a-4339-90e1-8f53f2021065 | PUBLIC | SYSTEM | empty text | empty text |
700e5ad4-4c37-44d1-99bf-9bbadf998cee | USERADMIN | SYSTEM | empty text | empty text |
95242298-a1da-4a10-bd8e-27260685c0a5 | ADMIN | SYSTEM | empty text | empty text |
ffe21b2e-2f54-4788-b808-78fbddec36a8 | DEVADMIN | INTERNAL | 80000000-37c5-454c-93f2-ec44ea4444ed | USER |
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 |
Was this page helpful?
Glad to hear it! Thank you for your feedback.
Sorry to hear that. Thank you for your feedback.