The administrator role assignments of the application.

Table-Specific Information

We recommend using the built-in Client Application Developer role to read and write data for this table.

SELECT

Reading data from this table requires Read Application Admin Role Assignments/permissions:read:applicationRoleAssignments permissions.

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

SELECT * FROM Administrators.ApplicationAdminRoleAssignments WHERE ApplicationId = '8f2c6a33-1f7f-458e-8b58-f92507742293';
SELECT * FROM Administrators.ApplicationAdminRoleAssignments WHERE ApplicationId IN ('8f2c6a33-1f7f-458e-8b58-f92507742293', '4441de0a-e4f2-47da-a217-545955eb23a5');

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

• ApplicationId supports the following operators: =, IN.

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

INSERT

Creating data in this table requires Update Application Admin Role Assignments/permissions:update:applicationRoleAssignments permission.

Refer to the query example below:

INSERT INTO Administrators.ApplicationAdminRoleAssignments (ApplicationId, AdminRoleId, ApplicableToEntityType, ApplicableToEntityId) VALUES ('8f2c6a33-1f7f-458e-8b58-f92507742293', '6f770b08-793f-4393-b2aa-b1d1587a0324', 'ENVIRONMENT', 'e2434246-9a5d-41d2-b2f0-fb1d18847b7c')

DELETE

Deleting data from this table requires Update Application Admin Role Assignments/permissions:update:applicationRoleAssignments permission.

Refer to the query example below:

DELETE FROM Administrators.ApplicationAdminRoleAssignments WHERE Id = '05aacbac-6fb4-4eeb-9ef7-e5af3172476f' AND ApplicationId = '8f2c6a33-1f7f-458e-8b58-f92507742293'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The role assignment identifier (UUID).
ApplicationId	String	False	Applications.Id	The identifier (UUID) of the application 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.