Mark procedure with authid current_user : Procedure Definition « Stored Procedure Function « Oracle PL / SQL

1. Oracle PL / SQL
2. Stored Procedure Function
3. Procedure Definition

Mark procedure with authid current_user

    
SQL>
SQL> select count(*) from dba_users;

1 row selected.


SQL>
SQL> create or replace procedure GET_ROW is
  2   x number;
  3  begin
  4   execute immediate 'select 1 from dba_users where rownum = 1' into x;
  5  end;
  6  /

Procedure created.

SQL> create or replace procedure GET_ROW authid current_user is
  2   x number;
  3   begin
  4       execute immediate 'select 1 from dba_users where rownum = 1' into x;
  5   end;
  6  /

Procedure created.

SQL>

   
    
    
    
  

Related examples in the same category