Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OBIEE 12c - Admin Tool - Database user privileges

BASSAM CHEHABEDDINESep 19 2019 — edited Sep 23 2019

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:

Odbc driver returned an error (SQLExecDirectW).

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

This post has been answered by BASSAM CHEHABEDDINE on Sep 23 2019

Jump to Answer

Added on Sep 19 2019

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #obiee

8 comments

686 views