create or replace trigger tr_logoff
before logoff on database
begin
insert into t_login_info(username,logoff_time,terminal,host,os_user,ip_address)
values(ora_login_user,sysdate,SYS_CONTEXT('USERENV','TERMINAL'),
SYS_CONTEXT('USERENV','HOST'),
SYS_CONTEXT('USERENV','OS_USER'),
ora_client_ip_address);
end;
-- 查看角色有哪些权限和哪些用户有哪些角色权限
select * from dba_roles;
select * from dba_role_privs;
-- 打开审计
alter system set audit_trail = db scope = spfile;
SQL> show parameter audit_trail;
SQL> alter system set audit_sys_operations=TRUE scope=spfile;
SQL> alter system set audit_trail=db scope=spfile;
SQL> show parameter audit;
2、审计dept表
SQL> audit all on dept;
SQL> select * from dept;
SQL> insert into dept values (90,'test','PanJin');
SQL> commit;
SQL> conn scott/mzl
SQL> insert into dept values(60,'June','ShangHai');
SQL> commit;
3、查看审计结果
SQL> select count(*) from dba_audit_trail;
4、禁止审计
SQL> noaudit all on dept;

ITPub博客

63

最新文章