Seeking Solution to Configure Single Sign-on (AD) with 12.2.0.1 Oracle Database for End-user
Seeking Solution to Configure Single Sign-on (AD) with 12.2.0.1 Oracle Database for End-user
Our Configuration:
We have a 2-Tier application that is NOT single-sign-on capable.
For this application, the user authentication/security are configured in 2-steps:
1. An application user is first created inside the application, assigned with an application level username and application level security profile, NO PASSWORD.
2. Then the DBA creates an oracle database user account (traditional password-authenticated) inside the oracle 12.2 database:
1). The database username must match the application username
2). The db username is given a password, which is the only way for the end-user to sign-on the application with.