Oracle Database on Database versions 19.17 and later.

On-premises Oracle Database release 19.16 and later, but not for Oracle Database 21c.

You can perform this integration in the following Oracle Database environments:

General Process of Integrating Microsoft Azure AD with Oracle Databaseīoth the Oracle and the Microsoft Azure administrators play roles in configuring the connection between Oracle Database and Microsoft Azure AD.

Oracle Database supports four types of use cases for connecting to an Oracle Database instance using Microsoft Azure Active Directory.

Use Cases for Connecting to an Oracle Database Using Azure AD.

Microsoft Azure users must be mapped to an Oracle Database schema and have the necessary privileges (through roles) before being able to authenticate to the Oracle Database instance.

Azure AD Users Mapping to an Oracle Database Schema.

Using an Azure AD token to access an Oracle database is similar to using OCI IAM tokens. Microsoft Azure Active Directory tokens follow the OAuth 2.0 standard with extensions.

Architecture of the Microsoft Azure AD Integration with an Oracle Database.

Users for Oracle Database can be centrally managed in a Microsoft Azure Active Directory (Azure AD) service. About Authorizing Microsoft Azure AD Users for an Oracle Database.You can use trace files to troubleshoot Oracle Database client connections with Azure AD connections. Trace Files for Troubleshooting Oracle Database Client Connections with Azure AD.You can configure client connections to connect with the Azure AD registered database Configuring Azure AD Client Connections to the Oracle Database.Proxy authentication allows an Azure AD user to proxy to a database schema for tasks such as application maintenance.

Configuring Microsoft Azure AD Proxy Authentication.Mapping Oracle Database Schemas and RolesĪzure AD users will be mapped to one database schema and optionally to one or more database roles.The Microsoft Azure AD integration with the Oracle Database instance requires the database to be registered with Azure AD so that the database can request the Azure AD public key. Configuring the Oracle Database for Microsoft Azure AD Integration.Introduction to Authorizing Microsoft Azure AD Users for an Oracle Databaseīefore you begin authenticating and authorizing Microsoft Azure AD users for an Oracle Database, you should understand the overall process.

Azure mfa