UserGroupAssociations
The user-group associations (group memberships) of the user.
View-Specific Information
SELECT
Reading data from this entity requires Read Group Membership/dir:read:groupMembership permission.We recommend using the built-in Identity Data Admin role.
To execute SELECT statements on this entity, 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 本製品 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 本製品.
Columns
| Name | Type | References | Description |
| UserId [KEY] | String | Users.Id | The identifier (UUID) of the user. |
| GroupId [KEY] | String | Groups.Id | The identifier (UUID) of the group in which the user belongs. |
| GroupName | String | The name of of the associated group. | |
| Type | String | 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'. |