show_authid.sql

来自「OReilly Oracle PL SQL Programming第4版源代码」· SQL 代码 · 共 8 行

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;