Skip to main content
Version: 24.3.x

SYS.MEMBERSHIP

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

Syntax
SELECT * 
FROM sys.membership

Example Output

role_namemember_namemember_type
ANALYSTgnarlyUSER
DATA_SCIENTISTPRODUCT_TEAMROLE
ADMINgnarlyUSER

Fields

FieldData TypeDescription
role_namevarcharThe user- or system-defined name of the role.
member_namevarcharThe name of the member that has been assigned the role.
member_typevarcharThe type of the member.
Enum: USER, ROLE