audit table access through specific roles -
07-15-2011
, 08:09 AM
Gentlemen
Does anybody knows if it is possible to implement, using standard
Oracle auditing procedures, a way to audit users acessing specific
tables , but only if they have been granted access to it by a specific
role or roles?
I mean, audit users accessing table A , who have been granted access
to it by the role A_READ, A_ALL, and not users who are accessing table
A who have been directly granted access on A, or through another role
which should not be monitored
Thanks
Sam |