OraFAQ Forum: Security » which role do I need this to get over the problem?

Home » RDBMS Server » Security » which role do I need this to get over the problem?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

which role do I need this to get over the problem? [message #31340]

Wed, 23 June 2004 10:42

SS
Messages: 46
Registered: November 2001

Member

SQL> declare
� 2�� v_tab varchar2(30);
� 3� begin
� 4�� select table_name into v_tab
� 5�� from dba_tables
� 6�� where rownum <= 1;
� 7� end;
� 8� /

PL/SQL procedure successfully completed.

SQL> create or replace procedure p111 as
� 2�� v_tab varchar2(30);
� 3�� begin
� 4�� select table_name into v_tab
� 5�� from dba_tables
� 6�� where rownum <= 1;
� 7�� end;
� 8� /

Warning: Procedure created with compilation errors.

SQL> show error
Errors for PROCEDURE P111:

LINE/COL ERROR
-------- --------------------------------------------------------
4/4�� PL/SQL: SQL Statement ignored
5/9�� PLS-00201: identifier 'SYS.DBA_TABLES' must be declared

Report message to a moderator

Re: which role do I need this to get over the problem? [message #31341 is a reply to message #31340]

Wed, 23 June 2004 11:25

sverch
Messages: 582
Registered: December 2000

Senior Member

SYS has to grant select on dba_tables to schema.

Report message to a moderator

Previous Topic:	Oracle Password
Next Topic:	can not populate audit log table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 16 23:26:03 CDT 2025