set echo on
create or replace view dba_procedures
as
select owner,
       object_name name,
       object_id,
       object_type,
       created,
       last_ddl_time,
       status,
       (select decode( bitand(options,16), 16, 'INVOKER', 'DEFINER' )
          from procedure$
         where obj# = dba_objects.object_id ) auth_id
  from dba_objects
 where object_type in ( 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'PACKAGE BODY' )
/

create public synonym dba_procedures for sys.dba_procedures
/

set echo off