SYS.MEMBERSHIP

The sys.membership table contains metadata for role membership.

The sys.roles table describes the available roles and their types. To appear in sys.membership, roles must have members and satisfy one of the following criteria in sys.roles:

• role_type of LOCAL
• role_type of EXTERNAL and created_by of SCIM

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. Valid values: USER ROLE