Home » RDBMS Server » Server Administration » ORA-00942: table or view does not exist
ORA-00942: table or view does not exist [message #133245] Thu, 18 August 2005 03:41 Go to next message
vgs2005
Messages: 123
Registered: April 2005
Senior Member
User XXX wrote a package that reads sys.dba_tab_columns, but it does not compile - displaying ORA-00942: table or view does not exist. The user has dba role. Strangely, it can 'select' from sys.dba_tab_columns in SQLPlus and TOAD. But cannot compile the package using those same tools... any hint?
thanks in advance..

Report message to a moderator

Re: ORA-00942: table or view does not exist [message #133283 is a reply to message #133245] Thu, 18 August 2005 06:57 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
you need an explicit select priv on a sys object.
Privileges enabled via roles are not effective with pl/sql.

Report message to a moderator

Re: ORA-00942: table or view does not exist [message #133288 is a reply to message #133245] Thu, 18 August 2005 07:13 Go to previous message
anujlal
Messages: 4
Registered: August 2005
Junior Member
Within a stored procedure, the privileges granted through roles
do not apply. You will have to give select privilege on the table
sys.dba_tab_columns to the user directly.

grant select on sys.dba_tab_columns to youruser

Regards
Anuj

Report message to a moderator

Previous Topic: Reg. session in trace file
Next Topic: act as a different schema
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 26 10:32:17 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.