Re: Authenticating Oracle using Azure AD

For the proof of concept the oracle documentation https://docs.oracle.com/en-us/iaas/exadatacloud/exacs/auth-ms-azure-ad-users-for-oracle-databases.html should suffice - except some small typos, like in the example

ALTER SYSTEM SET IDENTITY_PROVIDER_CONFIG = 'some config'

 value should be quoted string which is obvious, i didn't saw any more or less significant issues, on a free azure account it just worked, You might have some issues, if you have some nonstandard setup in your environment (for example - in my case it was not obvious, how to get working together AD Oauth token and local wallets - for different databases), or find the switch --allow-no-subscriptions for azlogin , but at the end it can be figured out.

Regards

Maxim

On Tue, Feb 27, 2024 at 6:20 PM Hameed Amir <dmarc-noreply_at_freelists.org> wrote:

> Hi,
>
> We are trying to authenticate Oracle database 19c connections using Azure
> AD. If anyone has done it successfully, I would appreciate your sharing the
> process with me.
>
>
>
> Thank you,
>
> Amir
>

--
http://www.freelists.org/webpage/oracle-l