Unable to configure Database as the Authentication Provider for Oracle Analytics Server 7.0

User_ANT46

We are attempting to configure Database as the Authentication Provider for Oracle Analytics Server 7.0 by following the steps outlined in the following URL: https://docs.oracle.com/en/middleware/bi/analytics-server/security-oas/configue-oracle-analytics-server-use-alternative-authentication-providers.html#GUID-69FA64EF-C2E6-4E28-9CEA-1DA568A6786A

We have successfully configured the authentication provider as SQLAuthenticator and can log in to the WebLogic admin console using a user stored in the database table. Furthermore, the user (User01) is also listed in the WebLogic console and assigned to the 'BIServiceAdministrator' group along with all other default groups.

 We have set the properties virtualize=true and OPTIMIZE_SEARCH=true in the Fusion Middleware, as specified in the mentioned URL. However, when attempting to log in as User01 through OAS, we encounter the following error.

Upon opening the ‘console’ >’User and Roles' in OAS through weblogic admin account, we observe that all Default Authenticator groups and users are displayed, but the SQLAuthenticator groups and users, including User01, are not visible in OAS.

any help in this regards will be appreciated.

Federico Venturin - Oracle

Hi @User_ANT46 ,

It may sound a stupid advice, but did you restart OAS (or at least the obis1 process)?

User_ANT46

Yes, i have restart all services.

Madasamy -Oracle

Can you check the below pointers

1. Check if you are able to see the users when you search it on Enterprise manager console against any application role
2. If this is not working in em as well, probably we need to revisit the adapter that you have created
   1. Check the logs ( bi_server1.logs ) by enabling DebugSecurityAtz and see if there are any errors in the adapters created
   2. Recreate the adapter if there is any issues on the adapter side from the logs review
3. If you have any specific error messages on the logs, we can guide further.

Thanks

SteveF-Oracle

Furthermore, the user (User01) is also listed in the WebLogic console and assigned to the 'BIServiceAdministrator' group along with all other default groups.

Additionally, as a quick test, assign the user directly (not through the group).

GayathriAnand-Oracle

Are you able to access /analytics endpoint (Classic Home)? If so suggest you attempt login to analytics -> my account -> Application Roles and validate the Application Roles assigned to user01.

User_73Z3T

Thanks to addressing all the issues, I have successfully resolved the situation. I reverted all the changes made previously and reconfigured the settings step by step, following the instructions outlined in the documentation.