JDBC Driver for Azure Active Directory

Build 24.0.9175

DirectoryRoleMembers

Identifies the members assigned to specific directory roles within the Azure AD environment.

Table Specific Information

Select

Get the members of Directory Roles in your Azure Active Directory. You can filter results by RoleId and UserId.

  • RoleId supports the '=' and IN operators.
  • UserId supports the '=' and IN operators.

For example, the following queries are processed server side:

SELECT * FROM DirectoryRoleMembers WHERE RoleId = '25502c98-94df-43fa-baf7-4a105e200030'

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

Columns

Name Type Description
RoleId [KEY] String The unique identifier for the directory role to which the user belongs. This value is used to associate a role with its members.
UserId [KEY] String The unique identifier for the user who is a member of the specified directory role. This value links the user to the role they belong to.

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