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: 25046
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: 64131
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: dblink variable refuses to compile
Next Topic: omit columns in report that uses NVL
Goto Forum:
  


Current Time: Wed Dec 07 12:29:47 CST 2016

Total time taken to generate the page: 0.10659 seconds