[FONT=Times New Roman][SIZE=3]  
[/SIZE][/FONT]
[FONT=Calibri][SIZE=3]Dear Team [/SIZE][/FONT]
[FONT=Times New Roman][SIZE=3]  [FONT=Calibri][SIZE=3]I am using DB2 v10 z/os database . Need expert guidance to figure out best way to track table activities ( Ex Delete, Insert,Update ) [/SIZE][/FONT]
[/SIZE][/FONT][FONT=Calibri][SIZE=3][B]Scenario [/B][/SIZE][/FONT]



[FONT=Times New Roman][SIZE=3]  [FONT=Calibri][SIZE=3]We have a table which is critical and many developer/testing team access on daily basis . We had instance where some deleted entire table . Since its test environment - the privileges are given as expected. [/SIZE][/FONT][/SIZE][/FONT]
[FONT=Times New Roman][SIZE=3]  [FONT=Calibri][SIZE=3][/SIZE][/FONT]
[FONT=Calibri][SIZE=3][B]Expectations[/B]: Is there a way to capture/track at user level ? Can we track which user deleted this table or updated/inserted etc. [/SIZE][/FONT]
[/SIZE][/FONT][FONT=Times New Roman][SIZE=3]
[/SIZE][/FONT]
[FONT=Calibri][SIZE=3][B]What I Tried[/B] : Trigger was my first thought . Second was temporal tables ( Not explored) [/SIZE][/FONT]


[FONT=Times New Roman][SIZE=3]  [FONT=Calibri][SIZE=3]I created a trigger with table that captures insert records with below example . I am able to figure out whenever insert/update/delete happens . however I am unable to capture which user did this . How can be track this ? Can we use SYSIBM.SYSTABAUTH ( Grantee column has user name ) But how can this be mapped [/SIZE][/FONT]
[/SIZE][/FONT][FONT=Times New Roman][SIZE=3]Example of insert logic[/SIZE][/FONT]
[FONT=Times New Roman][SIZE=3]
[/SIZE][/FONT]
CREATE TRIGGER TEST_SAMPLE_INSERT


       AFTER INSERT ON TEST_SAMPLE
       REFERENCING NEW AS N
       FOR EACH ROW
       BEGIN ATOMIC
       INSERT INTO X_TEST_SAMPLE ( action_timestamp,action_type,before_or_after, Other attributes of table )
  Values (current timestamp,'I','A',Other attributes of table )
[FONT=Times New Roman][SIZE=3]  
[/SIZE][/FONT]
[FONT=Times New Roman][SIZE=3]Any help appreciated . Would love to learn new ways to capture this at user level [/SIZE][/FONT]
[FONT=Calibri][SIZE=3] [/SIZE][/FONT]
[FONT=Times New Roman][SIZE=3]  
[/SIZE][/FONT]