UserApplicationRoleAssignments

Tracks application role assignments assigned to specific users for managing access and permissions.

Table Specific Information

Get the user application roles assignments in your Azure Active Directory. You can filter results by UserId.

For example, the following queries are processed server side:

SELECT * FROM UserApplicationRoleAssignments WHERE UserId = 'ffacf701-6caf-4228-9e3b-7e57c14122ee'

SELECT * FROM UserApplicationRoleAssignments WHERE UserId IN (SELECT Id FROM Users)


Name	Type	Description
UserId [KEY]	String	The unique identifier for the user assigned to the application role.
id [KEY]	String	The unique identifier for this specific application role assignment.
appRoleId	String	The unique identifier of the application role associated with the assignment.
createdDateTime	Datetime	The date and time when this application role assignment was created, in ISO 8601 format.
principalDisplayName	String	The display name of the principal (for example, user, group, or service principal) assigned the application role.
principalId	String	The unique identifier of the principal (for example, user, group, or service principal) associated with this role assignment.
principalType	String	The type of principal (for example, user, group, or service principal) associated with the role assignment.
resourceDisplayName	String	The display name of the target resource (for example, application or service) for the role assignment.
resourceId	String	The unique identifier of the target resource (for example, application or service) associated with the role assignment.