How do you configure the ReadOnlySQLAuthenticator not to use PlainTextPasswords?
Last updated on APRIL 18, 2016
Applies to:Business Intelligence Suite Enterprise Edition - Version 18.104.22.168.0  and later
Information in this document applies to any platform.
We have followed the following article:-
1338007.1 - How To Configure OBIEE 11g To Authenticate Using a Database Identity Store (SQL Authenticator)
Having setup the ReadOnlySQLAuthenticator within /console, authentication works using plain text passwords. However, we would like to un-check the 'PlainTextPasswords Enabled' and hash the passwords in the database using SHA-1.
Can you confirm what the ReadOnlySQLAuthenticator will use to try and match the hashed passwords to confirm authentication? Is hashing the passwords with SHA-1 enough?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms