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

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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Aug 02 11:30:18 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.