Oracle Database Discussions

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!

Oracle Integration with Active Directory - Is 1 Kerberos Login to Many Accounts Possible??

franquistNov 9 2023 — edited Nov 16 2023

Hello,

I have a single login certificate issued when I login to the Windows desktop.

Is Oracle Active Directory Integration a 1 to 1 map for each windows login?

For example, if I need 3 different logins to the Oracle DB for the same SSO user, do I need 3 unique Kerberos tickets or can I use a single Active Directory certificate to have multiple user accounts that would appear unique to Oracle?

If I store the logged in user id as a entry when inserting records, could I tell which account entered the information?

eastcoast_account = ABC Kerberos certificate

westcoast_account = ABC Kerberos certificate

south_account = ABC Kerberos certificate

eastcoast_account = ABC Kerberos certificate

westcoast_account = DEF Kerberos certificate

south_account = GHI Kerberos certificate

Thanks for any feedback

This post has been answered by selvakumar.nagulan on Nov 14 2023

Jump to Answer

Added on Nov 9 2023

#activedirectory, #authentication, #certificate, #configuration, #database, #kerberos, #multifactor

4 comments

551 views