- 论坛徽章:
- 0
|
本帖最后由 vcdog 于 2012-07-29 09:44 编辑
通过创建触发器对用户登录进行日志记录,对登录用户进行相关审计,记录登录用户,主机,系统用户及IP地址:
1.建表LOGON_TABLE :
SQL> create table LOGON_TABLE as
2 select sysdate logon_time,
3 sys_context('USERENV','SESSION_USER') username,
4 sys_context('USERENV','HOST') host,
5 sys_context('USERENV','OS_USER') os_user,
6 sys_context('USERENV','IP_ADDRESS') ip_address
7 from dual
8 /
Table created.
2.建触发器
SQL> create or replace trigger tri_logon after logon on database
2 begin
3 insert into LOGON_TABLE
4 ( logon_time,
5 username,
6 host,
7 os_user,
8 ip_address
9 )
10 values
11 ( sysdate,
12 sys_context('USERENV', 'SESSION_USER'),
13 sys_context('USERENV','HOST'),
14 sys_context('USERENV','OS_USER'),
15 sys_context('USERENV','IP_ADDRESS'));
16 end;
17 /
Trigger created.
一般这个在数据库安全加固时,都是有相关要求的。希望对你有帮忙!谢谢 |
|