Hi
Wonder if anyone can help with this.
I have a SQL query I have written which runs and returns results in Toad For Oracle.
However if I run the same SQL in Toad For Data Analysts I have no results.
I am using the same details for user name / user etc to connect to my Oracle database for both Toad For Oracle and Toad For Data Analysts.
The SQL query is running off Oracle views.
In Toad For Data Analysts on the “Explain Plan” tab of the query getting the message " ORA-01039: insufficient privileges on underlying objects of the view"
I am also running other SQL reporting using views and these work.
I have checked the grant details on the view I am using and it is the same as views I can already run reports on in Toad For Data Analysts
Any one have any ideas?
Thanks
Dave
Something else I thought about was could this be a time out issue?
The query dioes take almost 6 mins to run.
Message was edited by: Dave D.
ok have cracked it now!!!
All working
Message was edited by: Dave D.