Dimitar Dimitrov wrote:Thanks for your reply. Do you have by any chance an example of how to implement such an Custom Authentication Provider
There is no standard WLS authenticator that can authenticate against native Oracle DB accounts. If you need such authentication, you will have to implement a custom WLS authentication provider.
SQLAuthenticator/ReadOnlySQLAuthenticator cannot be used for authentication against native Oracle DB accounts. The reason is that these authentication providers must be configured with a SELECT statement that retrieves the user's password (using the username as an only parameter). This statement is used by the authenticator when it has to retrieve the user's password and to compare it with the credentials supplied by the user in the login form. Neither DBA_USERS nor any other Oracle database view provides access to the passwords of the native DB user accounts, so you are not able to provide such a SELECT statement in the authenticator's configuration.
Do you have by any chance an example of how to implement such an Custom Authentication ProviderUnfortunately, I do not have any experience in creation of custom authentication providers and I do not have any examples.
Dimitar Dimitrov wrote:Be wary when using ADF Security (OPSS) with a SQLAuthenticator.
... and then to utilize the SQLAuthenticator ...