The administrator role assignments 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 Role Assignments/permissions:read:groupRoleAssignmentspermission.

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.GroupAdminRoleAssignments WHERE GroupId = '13344eb0-1d6a-4715-9800-fce13f591925';
SELECT * FROM Administrators.GroupAdminRoleAssignments WHERE GroupId IN ('13344eb0-1d6a-4715-9800-fce13f591925', '76a9afd6-fd1c-4d55-9e84-7eea805f05c5');

The server 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 server.

INSERT

Creating data in this table requires Create Group Role Assignments/permissions:create:groupRoleAssignments permission.

Refer to the query example below:

INSERT INTO Administrators.GroupAdminRoleAssignments (GroupId, AdminRoleId, ApplicableToEntityType, ApplicableToEntityId) VALUES ('13344eb0-1d6a-4715-9800-fce13f591925', '6f770b08-793f-4393-b2aa-b1d1587a0324', 'ENVIRONMENT', 'e2434246-9a5d-41d2-b2f0-fb1d18847b7c')

DELETE

Deleting data from this table requires Delete Group Role Assignments/permissions:delete:groupRoleAssignments permission.

Refer to the query example below:

DELETE FROM Administrators.GroupAdminRoleAssignments WHERE Id = '48031a6d-3537-4653-a8b7-611484b14efa' AND GroupId = '13344eb0-1d6a-4715-9800-fce13f591925'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The role assignment identifier (UUID).
GroupId	String	False	Groups.Id	The identifier (UUID) of the group associated with the role assignment.
AdminRoleId	String	False	AdminRoles.Id	The identifier (UUID) of the role associated with the role assignment.
ApplicableToEntityType	String	False		The scope/level entity type for the role assignment. Possible values are: 'ORGANIZATION' and 'ENVIRONMENT', 'POPULATION' and 'APPLICATION'.
ApplicableToEntityId	String	False		The scope/level entity identifier (UUID) for the role assignment.
IsReadOnly	Boolean	True		Boolean value indicating whether this role assignment can be deleted by the current actor.