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_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