SYS.MEMBERSHIP

The sys.membership table contains metadata for role membership in the Dremio instance.

Syntax

SELECT * 
FROM sys.membership

Example Output

role_name	member_name	member_type
ANALYST	gnarly	USER
DATA_SCIENTIST	PRODUCT_TEAM	ROLE
ADMIN	gnarly	USER

Fields

Field	Data Type	Description
role_name	varchar	The user- or system-defined name of the role.
member_name	varchar	The name of the member that has been assigned the role.
member_type	varchar	The type of the member. Enum: USER, ROLE