小知识：如何赋予用户查看所有存储过程和触发器的权限

SQL> select * from session_privs where PRIVILEGE like '%TRIGGER%';

PRIVILEGE
--------------------------------------------------------------------------------
CREATE TRIGGER
CREATE ANY TRIGGER
ALTER ANY TRIGGER
DROP ANY TRIGGER
ADMINISTER DATABASE TRIGGER

SQL> select * from session_privs where PRIVILEGE like '%PROCEDURE%';

PRIVILEGE
--------------------------------------------------------------------------------
CREATE PROCEDURE
CREATE ANY PROCEDURE
ALTER ANY PROCEDURE
DROP ANY PROCEDURE
EXECUTE ANY PROCEDURE
DEBUG ANY PROCEDURE

6 rows selected.

--create procedure jingyu.sp_pro1
create or replace procedure jingyu.sp_pro1 is
  begin
  insert into jingyu.t1 values('Alfred','Zhao');
  end;
/

--create trigger jingyu.insertT1
create or replace trigger jingyu.insertT1
 after insert on jingyu.t1
 for each row
declare
 -- local variables here
begin
 dbms_output.put_line('新增员工成功');
end insertStaffHint;
/

grant DEBUG ANY PROCEDURE, ADMINISTER DATABASE TRIGGER to test;

jingyu.sp_pro1
jingyu.insertT1