VIEW: SYS.ALL_PROCEDURES

Source

View Text - Preformatted

select OWNER, OBJECT_NAME, PROCEDURE_NAME, OBJECT_ID, SUBPROGRAM_ID,
       OVERLOAD, OBJECT_TYPE,
       AGGREGATE, PIPELINED,
       IMPLTYPEOWNER, IMPLTYPENAME, PARALLEL,
       INTERFACE, DETERMINISTIC, AUTHID, ORIGIN_CON_ID
  from INT$DBA_PROCEDURES
 where OWNER = SYS_CONTEXT('USERENV', 'CURRENT_USER')
    or exists
       (select null from v$enabledprivs where priv_number in (-144,-141))
    or OBJ_ID(OWNER, OBJECT_NAME, OBJECT_TYPE#, OBJECT_ID) in
       (select obj#
          from sys.objauth$
         where grantee# in (select kzsrorol from x$kzsro)
           and privilege# = 12)

View Text - HTML Formatted

SELECT OWNER
, OBJECT_NAME
, PROCEDURE_NAME
, OBJECT_ID
, SUBPROGRAM_ID
, OVERLOAD
, OBJECT_TYPE
, AGGREGATE
, PIPELINED
, IMPLTYPEOWNER
, IMPLTYPENAME
, PARALLEL
, INTERFACE
, DETERMINISTIC
, AUTHID
, ORIGIN_CON_ID
FROM INT$DBA_PROCEDURES
WHERE OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER') OR EXISTS (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-144
, -141)) OR OBJ_ID(OWNER
, OBJECT_NAME
, OBJECT_TYPE#
, OBJECT_ID) IN (SELECT OBJ#
FROM SYS.OBJAUTH$
WHERE GRANTEE# IN (SELECT KZSROROL
FROM X$KZSRO)
AND PRIVILEGE# = 12)