UserApplicationRoleAssignments
Tracks application role assignments assigned to specific users for managing access and permissions.
View-Specific Information
SELECT
You can filter results by UserId.- UserId supports the =, IN operators.
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)
Columns
| 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. |