8 Replies Latest reply on Sep 23, 2019 8:19 PM by BASSAM CHEHABEDDINE

    OBIEE 12c - Admin Tool - Database user privileges

    BASSAM CHEHABEDDINE

      Dear Gents,

       

      I would highly appreciate you help on the following ...

       

      I connecting OBIEE 12C to oracle Database, and in admin tool i am putting the main schema name and password where i want to avoid that as it is not the best practice, while adding a new user

       

       

      create user reports identified by 123456

      create role bi_user_role

      grant select all_table to bi_user_role

      grant create session to bi_user_role

      GRANT CONNECT TO bi_user_role

        grant bi_user_role to reports

       

       

      and it shows errors while updating the row count in admin tool

       

      Capture.PNG

       

       

      and also the OBIEE answers is not working and give the following:

       

      Error
      View Display Error

      Odbc driver returned an error (SQLExecDirectW).

      http://10.2.5.225:9502/analytics/res/v-y7rKsZ234co/sk_blafp/common/errorminus.gif  Error Details

      Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P

       

       

      State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)

       

       

      State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)

       

       

      State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 942, message: ORA-00942: table or view does not exist at OCI call OCIStmtExecute. (HY000)

       

       

      State: HY000. Code: 17010. [nQSError: 17010] SQL statement preparation failed. (HY000)

       

       

      Please have your System Administrator look at the log for more details on this error.

       

      Looking forward to your advise ...
      Best Regards,
      Bassam