You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Role/Privelege for Explain Plan from SQL Query on data model

in Reporting and Analytics for ERP 4 comments

One of our Reporting analyst user is getting an error that occurs when attempting to generate an Explain Plan from a SQL query on his reports.

"Error Msg = ORA-01039: insufficient privileges on underlying objects of the view
      at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:531)"


Do they need BI Admin access to generate an explain plan? or what role they need other than BI Administrator


Thanks
Vj

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!