automatically turning on auditing for specific users
Guess2Jul 26 2012 — edited Jul 26 2012oracle 10.2.0.5
We don't need any fancy auditing such as fine grained auditing. We need to audit all actions of specific privilege users (DBAs users, etc...). We know the commands, but we want a way to make sure auditing is on automatically (by 'we', i mean management).
the concern is we may miss turning on auditing when we create new users. So we want a way to check to make sure it is on. I can think of 2 options, but I don't really like them. I can always use them, but I was wondering if there is a better way.
1. logon trigger: only a tiny percentage of people who login will need to be audited. So I would prefer not to check every time someone logs in and fire a login trigger.
2. run a job every 5 minutes to check specific users to make sure they are being audited. Running a job every 5 minutes is a bit excessive. So again, I would prefer a better way to do this.
is there a way using an oracle feature that will ensure certain users are being audited? anything built into fine grained auditing? we are not looking to limit the auditing to certain queries or tables, we want to audit all actions by privileges users. This isn't really critical. I was just looking for a better way to do this.