How to Authenticate Oracle BI Publisher(Enter Prise) username and password from oracle data base

Question

We saved username and password in database and we authenticate these from database for other apps.

From a table of users column username and password.

I want to authenticate users from data base .

Please guide me.

Syedsalmancs110 · Answer

How about configuring a Read-Only SQL Authentication (ReadOnlySQLAuthenticator) with Weblogic to make your database authentication as part of Fusion Middleware Security.

(Version 11.1.1.7.x document link) 3.4.3 Configuring a Database as the Authentication Provider

(Version 11.1.1.9.x document link) 3.4.3 Configuring a Database as the Authentication Provider

FYI, ReadOnlySQLAuthenticator is used to Authenticate and Authorize users present in database, give above link a read you will understand.