Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

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

Accepted answer
156
Views
6
Comments
User_ANT46
User_ANT46 Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

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.

image.png

 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.

image.png

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.

image.png

any help in this regards will be appreciated.

Best Answer

Answers

  • User_ANT46
    User_ANT46 Rank 1 - Community Starter

    Yes, i have restart all services.

  • Madasamy -Oracle
    Madasamy -Oracle Rank 6 - Analytics Lead

    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
    SteveF-Oracle Mod

    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
    GayathriAnand-Oracle Mod

    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
    User_73Z3T Rank 1 - Community Starter

    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.