0 Replies Latest reply: Jan 4, 2013 4:14 AM by SyamPrasad N RSS

    Issue With External Table Authentiaction in OBIEE 11.1.1.6.4

    SyamPrasad N
      Hi,

      We are trying to implement security through External table Authentication in OBIEE 11.1.1.6.4.As a part of this process,we want to pass the credential values which are entered in login screen to the below query in the GET SQL PASSWORD section of ReadonlySQLAuthentication Provider.

      select encryptfn(:USER,:PASSWORD) from Users where Username=?

      Credential values which we are entering in Analytics Answers login screen are not getting passed into :USER and :PASSWORD.

      Can anybody please help us what is the exact variable we should use in place of :USER and :PASSWORD in the function called from the above select statement?

      Thanks,
      Syam