Skip to Main Content

How would you (is it possible to) use a different database username than the SSO login name?

Our techstack consist of:
Oracle Forms, using RDBMS 19c
Oracle Access Manager / OHS / webgate, using Microsoft AD userstore
We would like to access the Forms application using SSO. All users have a unique email address and database account stored in Microsoft AD. The email address is used for SSO login, the corresponding database account should be used to access Forms/DB.
We would like to use the DB proxy user and group RAD, as one RAD per enduser seems very error prune to maintain.
Question: would it be possible to use the SSO username (example "") and pass another corresponding AD field (uid="sraft") to be used as the database username login?

Post Details
Added on Oct 1 2021