Access to Oracle database with AD user without password, like Sqlserver.

User_20ZZ2

Hi all,

I received a request from developer team.

They hava webserver running IIS. IIS service is running under an administrative user.

IIS access to a SQLserver database using integrated authentication, so they don't need to use a password.

The request is: Is it possible to use the same access from IIS to Oracle Database (12.c) ?

Even if I need some features that I have to pay?

Thanks in advance.

EdStevens

Look at CREATE USER IDENTIFIED GLOBALLY ..

I'v never done it myself, but saw a colleague demonstrate it once at a conference. I believe you have to install Oracle Internet Directory (OID), and you can then sync that with LDAP. Sorry I can't provide more details, but at least I can confirm that it is possible. Perhaps someone else will weigh in with more details.

This should help you get started: https://docs.oracle.com/en/middleware/idm/internet-directory/12.2.1.3/index.html

Emad Al-Mousa

Hi,

there is a feature called CMU: https://docs.oracle.com/en/database/oracle/oracle-database/18/dbseg/integrating_mads_with_oracle_database.html#GUID-9739D541-FA9D-422A-95CA-799A4C6F488D

Regards,

Emad