Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

User_20ZZ2Apr 29 2021

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.

Comments

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

1 - 2

Post Details

Added on Apr 29 2021
#database-security, #database-security-general
2 comments
197 views