记录用户对某一张表的操作记录（oracle为例）

1.创建记录信息表
create table emp2_log
(
ename varchar2(30) ,
eaction varchar2(20),
etime date
);

2.创建触发器，执行对表的操作触发
create or replace trigger trig
after insert or delete or update on emp2
for each row
begin
if inserting then
insert into emp2_log values(USER, 'insert', sysdate);
elsif updating then
insert into emp2_log values(USER, 'update', sysdate);
elsif deleting then
insert into emp2_log values(USER, 'delete', sysdate);
end if;
end;