Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00942: table or view does not exist (Oracle 10g,XP)
icon14.gif  ORA-00942: table or view does not exist [message #387861] Sat, 21 February 2009 00:13 Go to next message
rakeshramm
Messages: 175
Registered: September 2006
Location: Oracle4u.com
Senior Member


When i am executing a package from test schema but accessing tables (ie:emp,dept,branch) from Scott schema ,its shows error
ORA-00942: table or view does not exist . So that i grant both user dba role then also same error is occurring .
I know that its due privilege settings ,but how to resolve it


Thanks
Re: ORA-00942: table or view does not exist [message #387862 is a reply to message #387861] Sat, 21 February 2009 00:18 Go to previous messageGo to next message
BlackSwan
Messages: 25571
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you

Privs acquired via ROLE do no apply within PL/SQL.
Re: ORA-00942: table or view does not exist [message #387863 is a reply to message #387861] Sat, 21 February 2009 00:28 Go to previous message
Michel Cadot
Messages: 65143
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This has been answered about a zillion times and not so far than yesterday so please search BEFORE posting.

Regards
Michel
Previous Topic: omit columns in report that uses NVL
Next Topic: Pivot Table
Goto Forum:
  


Current Time: Sat Aug 19 10:13:25 CDT 2017

Total time taken to generate the page: 0.04853 seconds