The authentication (sign-on) policy 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 Sign-on Policy Assignment/applications:read:signOnPolicyAssignment permission.

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.ApplicationAuthenticationPolicyAssignments WHERE ApplicationId = '8f2c6a33-1f7f-458e-8b58-f92507742293';
SELECT * FROM Administrators.ApplicationAuthenticationPolicyAssignments WHERE ApplicationId IN ('8f2c6a33-1f7f-458e-8b58-f92507742293', '4441de0a-e4f2-47da-a217-545955eb23a5');

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

INSERT

Creating data in this table requires Create Sign-on Policy Assignment/applications:create:signOnPolicyAssignment permission.

Refer to the query example below:

INSERT INTO Administrators.ApplicationAuthenticationPolicyAssignments (ApplicationId, AuthenticationPolicyId, Priority) VALUES ('8f2c6a33-1f7f-458e-8b58-f92507742293', '4b07563c-9f17-4aac-ab4d-a79b7ed1b8dc', 1)

DELETE

Deleting data from this table requires Delete Sign-on Policy Assignment/applications:delete:signOnPolicyAssignment permission.

Refer to the query example below:

DELETE FROM Administrators.ApplicationAuthenticationPolicyAssignments WHERE ApplicationId = '8f2c6a33-1f7f-458e-8b58-f92507742293' AND Id = 'cd058f8c-0949-4634-8623-331530f8ee02'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The authentication policy assignment identifier (UUID).
ApplicationId	String	False	Applications.Id	The identifier (UUID) of the application to which the authentication policy is assigned.
AuthenticationPolicyId	String	False	AuthenticationPolicies.Id	The identifier (UUID) of the authentication policy assigned to the application.
Priority	Integer	False		The order in which the authentication policy referenced by this assignment is evaluated during an authentication flow relative to other authentication policies. An assignment with a lower priority will be evaluated first.