摘要:
逛论坛的时候发现一个好脚本,记录下来以备日后有用: 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_ 阅读全文