Hi

I want to set up a read only SQL Authenticator on OBIEE 12c but I'm having problems logging into OBIEE.  I can see the users and groups from my SQL tables listed in the Weblogic LDAP under myrealm-> users & groups but can't

login as any user to OBIEE /analytics.  I am using plain text passwords and ticked Plaintext Passwords Enabled.  I get the below error in the obis1-diagnostic.log:-

[2016-09-27T11:12:10.328+01:00] [OBIS] [ERROR:1] [] [] [ecid: 8b47850f-4ee6-4e77-b2b0-e3eb5431e097-00000161,0:1:1:6] [sik: ssi] [tid: 47507700]  [nQSError: 13057] Error From BI Security Service: [BISecurity] [oracle.bi.security.centaurus.GetSubjectAction::execute] [OBI-SEC-00501] Could not find user "test" in the Identity Store.. [[^M

**********  Task: 1. Running for (mls): 1189 **********
Description: Authenticate
RPID: ssi; user: test; AppType: ; Offline: false

It claims it can't find the user test in the identity store but I can see it listed under users & groups.  I'm thinking possible I've missed some configuration somewhere?

Any help would be great.

Thanks in advance!

Adrian