JDBC Driver for Azure Active Directory

Build 22.0.8509

UserApplicationRoleAssignments

UserApplicationRoleAssignments table for Azure AD data provider.

Table Specific Information

Select

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

  • UserId supports the '=' and 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 UserId of the ApplicationRoleAssignment.
id [KEY] String The id of the ApplicationRoleAssignment.
appRoleId String The appRoleId of the ApplicationRoleAssignment.
createdDateTime Datetime The createdDateTime of the ApplicationRoleAssignment.
principalDisplayName String The principalDisplayName of the ApplicationRoleAssignment.
principalId String The principalId of the ApplicationRoleAssignment.
principalType String The principalType of the ApplicationRoleAssignment.
resourceDisplayName String The resourceDisplayName of the ApplicationRoleAssignment.
resourceId String The resourceId of the ApplicationRoleAssignment.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8509