The parent groups associations of the group.

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 GroupId column must be specified in the criteria as shown in the examples below:

SELECT * FROM Administrators.ParentGroupAssociations WHERE GroupId = '13344eb0-1d6a-4715-9800-fce13f591925';
SELECT * FROM Administrators.ParentGroupAssociations WHERE GroupId IN ('13344eb0-1d6a-4715-9800-fce13f591925', '76a9afd6-fd1c-4d55-9e84-7eea805f05c5');

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

• GroupId 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.ParentGroupAssociations (GroupId, ParentGroupId) VALUES ('13344eb0-1d6a-4715-9800-fce13f591925', '76a9afd6-fd1c-4d55-9e84-7eea805f05c5')

DELETE

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

Refer to the query example below:

DELETE FROM Administrators.ParentGroupAssociations WHERE GroupId = '13344eb0-1d6a-4715-9800-fce13f591925' AND GroupId = '76a9afd6-fd1c-4d55-9e84-7eea805f05c5'

Columns

Name	Type	ReadOnly	References	Description
GroupId [KEY]	String	False	Groups.Id	The identifier (UUID) of the group.
ParentGroupId [KEY]	String	False	Groups.Id	The identifier (UUID) of the parent group in which the group belongs.
ParentGroupName	String	True		The name of of the associated parent group.
Type	String	True		A string indicating whether the group is directly related to the parent group or indirectly related (inherited from another child group that belongs to the group). Possible values are: 'DIRECT' and 'INDIRECT'.