基于值的审计

botang

1. create or replace trigger trg2
   
2. after update of salary on hr.t062ad11_b
   
3. referencing new as new old as old
   
4. for each row
   
5. begin
   
6.   if :old.salary >= :new.salary then
   
7.      raise_application_error(-20000, 'Modify lesser error.');      
   
8.   end if;
   
9. end;
   
10. /

复制代码

1. create or replace trigger trg3
   
2. after update of salary on hr.t062ad11_b
   
3. referencing new as new old as old
   
4. for each row
   
5. begin
   
6.   if :old.salary != :new.salary then
   
7.      insert into tvalue
   
8.       values (sys_context('userenv','os_user')||' ' ||sys_context('userenv','session_user') ||' '||
   
9.              sys_context('userenv','current_user')||' '||sys_context('userenv','ip_address')||' '||sys_context('userenv','authentication_method')||' '
   
10.       ||to_char(sysdate,'YYYY-MM-DD:HH24:MI:SS')||' modified '||:new.salary||' '||:old.salary);      
    
11.   end if;
    
12. end;
    
13. /
    
14. 
    

复制代码

oracle HR SYS 172.25.250.254 PASSWORD 2020-11-01:21:45:12 modified 48004 24002
oracle HR SYS 172.25.250.254 PASSWORD 2020-11-01:21:45:12 modified 40002 20001
oracle HR SYS 172.25.250.254 PASSWORD 2020-11-01:21:45:12 modified 20002 10001
oracle HR SYS 172.25.250.254 PASSWORD 2020-11-01:21:45:12 modified 10004 5002