分类: Oracle
2008-04-11 19:58:11
条件:在某用户下创建表和触发器,该用户需有DBA权限。
步骤:
1. 创建表:
create table session_history
( username varchar2(20),
logon_date varchar2(20),
ip varchar2(20));
2. 创建触发器:
CREATE OR REPLACE TRIGGER logon_history
AFTER LOGON ON DATABASE
BEGIN
insert into session_history
select SYS_CONTEXT ('userenv','session_user'),to_char(sysdate,'yyyy-mm-dd hh24:mm:ss'),SYS_CONTEXT('USERENV','IP_ADDRESS') from dual;
commit;
END;
/
3 . 完成
4 . 测试:
select * from session_history;
conn user1/pwd1@ll1
select * from session_history;
conn user2/pwd2@ll2
select * from session_history;