This content has been marked as final. Show 4 replies
Only way is to set audit for everyone else except that user.
There is no "audit..." command option to exclude selected users.
Any particular reason why? Trying the reduce the amount of audit entries?
Yes. Security team request to reduce the amount of the audit data based on the user account. Can I use FGA to implement it? Thanks.
Security team request to reduce the amount of the audit data based on the user account. Can I use FGA to implement it?possible as it lets you specify the conditions necessary for an audit record to be generated:
FGA policies are programatically bound to the object (table, view) by using the 'dbms_fga' package. It allows you to create any desired condition,
for example: Audit an event only when the following conditions are true:
A table is accessed between 6 p.m. and 6 a.m. and on Saturday and Sunday.
An IP address from outside the corporate network is used.
A specific column has been selected or updated.
A specific value for this column has been used.
more detail available on Oracle by example
Thanks for your response. I really hope oracle can add this as new feature for audit policy. This is not the first time I am trying to do it.