Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Accessing V$ Tables
From: Srinivasan Sankar <srinisankar_at_nospam.com>
4/2 PL/SQL: SQL Statement ignored 6/7 PLS-00201: identifier 'SYS.V_$SQLAREA' must be declared<< when trying to access v$ tables in procedure
It appears to be a security problem. The v$ tables are usually synonyms of v_$ views. Connect as 'sys' and grant select on the v_$ view to the procedure owner. Oracle provides a script usually in the $ORACLE_HOME/rdbms/admin directory that grants access on a lot of the more commonly accessed v$ tables to either a role or public. You can search for it by greping on "v\$" or I think it has the word monitor in the script. Anyway you should be able to find it easy enough and it will provide example grant sql or you may want to run the script (as sys).
Mark Powell -- The only advise that counts is the advise that you follow so follow your own advise Received on Wed Oct 22 1997 - 00:00:00 CDT