/** * drop語(yǔ)句的審計(jì)日志表 */ create table drop_log ( session_id int not null, -- sessionid drop_time date, -- drop的時(shí)間 ip_address varchar2(20), -- ip地址 object_owner varchar2(30), -- 對(duì)象的所有者 object_name varchar2(30), -- 對(duì)象名稱 object_type varchar2(20), -- 對(duì)象類型 drop_by_user varchar2(30) -- 執(zhí)行drop語(yǔ)句的用戶 ); create or replace trigger drop_info after drop on mfg0513user.schema -- 在mfg0513user用戶上創(chuàng)建審記DROP的觸發(fā)器 begin insert into drop_log (session_id, drop_time, ip_address, object_owner, object_name, object_type, drop_by_user) values(USERENV('SESSIONID'), sysdate, SYS_CONTEXT('USERENV','IP_ADDRESS'), sys.dictionary_obj_owner, sys.dictionary_obj_name, sys.dictionary_obj_type, sys.login_user); end; |