The administrator role assignments of the user.

Table-Specific Information

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

SELECT

Reading data from this table requires Read User Role Assignments/permissions:read:userRoleAssignments permission.

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

SELECT * FROM Administrators.UserAdminRoleAssignments WHERE UserId = 'f45bb04b-d7ee-4f84-ab83-7fe3919405ae';
SELECT * FROM Administrators.UserAdminRoleAssignments WHERE UserId IN ('f45bb04b-d7ee-4f84-ab83-7fe3919405ae', '4cbf5435-6c39-49f9-8c8f-cee7c1cd8a6b');

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

INSERT

Creating data in this table requires Update User Role Assignments/permissions:update:userRoleAssignments permission.

Refer to the query example below:

INSERT INTO Administrators.UserAdminRoleAssignments (UserId, AdminRoleId, ApplicableToEntityType, ApplicableToEntityId) VALUES ('f45bb04b-d7ee-4f84-ab83-7fe3919405ae', '6f770b08-793f-4393-b2aa-b1d1587a0324', 'ENVIRONMENT', 'e2434246-9a5d-41d2-b2f0-fb1d18847b7c')

DELETE

Deleting data from this table requires Update User Role Assignments/permissions:update:userRoleAssignments permission.

Refer to the query example below:

DELETE FROM Administrators.UserAdminRoleAssignments WHERE Id = '4ff811b4-c4ee-469c-bbbc-33cf4f2698ae' AND UserId = 'f45bb04b-d7ee-4f84-ab83-7fe3919405ae'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The role assignment identifier (UUID).
UserId [KEY]	String	False	Users.Id	The identifier (UUID) of the user 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.
InheritanceType	String	True		A string indicating whether the role assignment is directly configured from the user or indirectly inherited from a group that the use belongs in. Possible values are: 'DIRECT' and 'INDIRECT'.