1.记录数据库的某个用户对于数据库的操作,首先要一个记录操作信息的表:
2.对应的trigger,下面以oracle的dept表为例子:
1 create table mylog(
2 user_name varchar2(10),
3 oper_time date,
4 operate_type varchar2(10)
5* )
2.对应的trigger,下面以oracle的dept表为例子:
SQL> create or replace trigger my_tri
2 after insert or update or delete on dept
3 begin
4 if inserting then
5 insert into mylog values(user,sysdate,'insert');
6 elsif updating then
7 insert into mylog values(user,sysdate,'update');
8 else
9 insert into mylog values(user,sysdate,'delete');
10 end if;
11 end;