JDBC Driver for Microsoft Entra ID

Build 26.0.9770

DirectoryRoleTemplates

Offers a template view of all directory roles available for use.

View-Specific Information

SELECT

Id must be filtered using either the = or IN operator. For example:
SELECT * FROM DirectoryRoleTemplates WHERE Id = '62e90394-69f5-4237-9190-012177145e10'
SELECT * FROM DirectoryRoleTemplates WHERE Id IN ('62e90394-69f5-4237-9190-012177145e10', '2af84b1e-32c8-42b7-82bc-daa82404023b')
SELECT * FROM DirectoryRoleTemplates WHERE DisplayName LIKE '%Admin%'

Columns

Name Type Description
id [KEY] String The unique identifier for the directory role template, typically used as the primary key.
deletedDateTime Datetime The timestamp indicating when the directory role template was deleted, useful for auditing and recovery.
description String A detailed explanation or notes about the purpose and scope of the directory role template.
displayName String The human-readable name of the directory role template, used for display in user interfaces.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770