I have been look into how to track user activity within our database. We have two compliance needs one is to track all inquiry activity and secondarily we need to track the add, modify, delete activity.
It appears from my research so far that there may be journal reporting software solution for the add, modify, delete portion of the requirements. Though one product as-tracer appears to be no longer available and the other I have found mentioned ISP journal reporting has very sketchy descriptions of what it does and what the output would look like/if user ids are captured. Does anyone have any information on these products or other solutions to this compliance issue. We are processing between 400,000 and 600,000 transactions daily.