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

    OBIEE 12c - Admin Tool - Database user privileges


      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





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


      View Display Error

      Odbc driver returned an error (SQLExecDirectW).  Error Details




      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,