show_authid.sql

OReilly Oracle PL SQL Programming第4版源代码

SELECT   AUTHID
       , p.object_name program_name
       , procedure_name subprogram_name
    FROM user_procedures p, user_objects o
   WHERE p.object_name = o.object_name
     AND p.object_name LIKE '&1'
ORDER BY AUTHID, procedure_name;