SYS.ORGANIZATION.ROLES

The sys.organization.roles table contains metadata for roles in an organization.

Syntax

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

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

Was this page helpful?

Glad to hear it! Thank you for your feedback. Sorry to hear that. Thank you for your feedback.