How do you configure the ReadOnlySQLAuthenticator not to use PlainTextPasswords?

(Doc ID 1459438.1)

Last updated on APRIL 18, 2016

Applies to:

Business Intelligence Suite Enterprise Edition - Version [1308] 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