Dremio Cloud
Dremio Software
 
On this page

    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