Home » RDBMS Server » Security » which role do I need this to get over the problem?
which role do I need this to get over the problem? [message #31340] Wed, 23 June 2004 10:42 Go to next message
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
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 Go to previous message
sverch
Messages: 582
Registered: December 2000
Senior Member
SYS has to grant select on dba_tables to schema.
Previous Topic: Oracle Password
Next Topic: can not populate audit log table
Goto Forum:
  


Current Time: Mon Sep 20 13:06:24 CDT 2021