摘要:逛论坛的时候发现一个好脚本,记录下来以备日后有用: CREATE OR REPLACE TRIGGER sys.trg_work_logAFTER LOGON ON DATABASEdeclarev_program_name varchar2(200);v_username varchar2(100);v_ip varchar2(18);v_error varchar2(1000);beginselect username,program,SYS_CONTEXT('USERENV','IP_ADDRESS') into v_username,v_program_ 阅读全文
posted @ 2011-04-22 00:34 killkill 阅读(852) 评论(0) 推荐(0) 编辑