The user-group associations (group memberships) of the user.

Table-Specific Information

We recommend using the built-in Identity Data Admin role to read and write data for this table.

SELECT

Reading data from this table requires Read Group Membership/dir:read:groupMembership permission.

To execute SELECT statements on this table, the UserId column must be specified in the criteria as shown in the examples below:

SELECT * FROM Administrators.UserGroupAssociations WHERE UserId = 'f45bb04b-d7ee-4f84-ab83-7fe3919405ae';
SELECT * FROM Administrators.UserGroupAssociations WHERE UserId IN ('f45bb04b-d7ee-4f84-ab83-7fe3919405ae', '4cbf5435-6c39-49f9-8c8f-cee7c1cd8a6b');

The connector uses the PingOne Platform API to process WHERE clause conditions built with the following columns and operators.

• UserId supports the following operators: =, IN.

All other filters are processed client-side within the connector.

INSERT

Creating data in this table requires Create Group Membership/dir:create:groupMembership permission.

Refer to the query example below:

INSERT INTO Administrators.UserGroupAssociations (UserId, GroupId) VALUES ('f45bb04b-d7ee-4f84-ab83-7fe3919405ae', '13344eb0-1d6a-4715-9800-fce13f591925')

DELETE

Deleting data from this table requires Delete Group Membership/dir:delete:groupMembership permission.

Refer to the query example below:

DELETE FROM Administrators.UserGroupAssociations WHERE UserId = 'f45bb04b-d7ee-4f84-ab83-7fe3919405ae' AND GroupId = '13344eb0-1d6a-4715-9800-fce13f591925'

Columns

Name	Type	ReadOnly	References	Description
UserId [KEY]	String	False	Users.Id	The identifier (UUID) of the user.
GroupId [KEY]	String	False	Groups.Id	The identifier (UUID) of the group in which the user belongs.
GroupName	String	True		The name of of the associated group.
Type	String	True		A string indicating whether the user is directly related to the group or indirectly related (inherited from another child group that belongs to the group OR dynamically added with a filter). Possible values are: 'DIRECT' and 'INDIRECT'.