Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 12c Default Password encryption?

Question
1
Views
0
Comments
OracleUser_MUC6U
OracleUser_MUC6U Rank 5 - Community Champion

Hi,

I've configured a Read-Only SQL Authenticator to authenticate OBIEE user login against user details from database tables which is working bar the password decryption. However the users password set in the db table has been encrypted by a third party application using the PBKDF Salted encryption which OBIEE does not recognize.

I want to test out what encrypted hashed values OBIEE will recognize via the RO SQL Authenticator.  I've encrypted a test user's password using SHA-1 encryption and inserted it into the password column in the users database table, which I thought OBIEE would recognizing but login fails.

I've read here 3 Using Alternative Authentication Providers  (step 10) that OBIEE default algorithm is SHA-1 and assumed OBIEE should recognize the SHA-1 hashed value I provided.

Anyone know if this is possible to provide OBIEE with the hash value or has any ideas on what the default Hashing OBIEE uses?

Thanks

Adrian