This content has been marked as final. Show 3 replies
user12191348 wrote:Depends on what you want to do ... simply audit what these 'xnnnn' users do, or put limits on what they do?
I have several tables in huge db, each one has 1M+ transactions per hour from Application.
Tables located under schema APPTABLEOWN, application connected to schema APPTABLECONN which has synonyms to tables.
As well, some employees can connect and run DML there, using personal accounts like XNNNNNNN where X - letter and N - numbers
Idea is to capture (trace) any DML ran by these users, but somehow without performance impact.
DB is 10G (10.2.0.4), ASM.
What do you recommend to use for such task? FGA? Logminer? Something else? FGA looks reasonable here, but will it impact performance? There are several millions app dml's to 1 employee's one....
Thank you in advance.