1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
| CREATE OR REPLACE TRIGGER TRG_AUDIT
BEFORE INSERT OR UPDATE OR DELETE ON x.table_test
DECLARE
CURSOR cur_user IS
select x.table_seq_audit.NEXTVAL as ID,
USERNAME,
OSUSER,
sysdate as date_op,
machine
from sys.V_$SESSION WHERE audsid=userenv('sessionid');
BEGIN
For CUR in cur_user Loop
INSERT INTO x.table_audit (id_audit,USERNAME,USER_ID,AUDIT_DATE,EXTERNAL_NAME)
VALUES (CUR.ID,
CUR.USERNAME,
CUR.OSUSER,
CUR.date_op,
CUR.machine);
End loop ;
END TRG_AUDIT;
/ |
