We have a Read Only SQL Authenticator Provider configured in WebLogic and in Oracle Analytics (BI) we are using the HTTP Cookie method to get a token that represents an authenticated user. We reference the token in the provider specific queries and SSO into Oracle Analytics works. However, the User ID and Display Name field when you click on My Account shows the token value coming from the cookie - even though we have defined the queries for describing the user, which select the username from a user table. Observing the queries being run against the database it appears as though only the SQL User Exists query (and another query that gets group memebership) runs - the query to get the user description doesn't run. So it appears that SSO using the cookie bypasses enriching the user object. Is there something that can be done to force those queries to run?
The version is OAS 2023 on Windows 2022 server, weblogic 12.2.1.4.0
thanks,
josh
