JDBC Driver for Azure Active Directory

Build 24.0.9175

GroupApplicationRoleAssignments

Tracks application role assignments assigned to specific groups for managing permissions.

Table Specific Information

Select

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

  • UserId supports the '=' and IN operators.

For example, the following queries are processed server side:

SELECT * FROM GroupApplicationRoleAssignments WHERE GroupId = 'ffacf701-6caf-4228-9e3b-7e57c14122ee'

SELECT * FROM GroupApplicationRoleAssignments WHERE GroupId IN (SELECT Id FROM Groups)

Columns

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

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175