audit table access through specific roles

From: sam <samuel.tiroles_at_gmail.com>
Date: Fri, 15 Jul 2011 06:09:09 -0700 (PDT)
Message-ID: <61cd14c0-6866-4f31-8d4f-3f3416c79065_at_c41g2000yqm.googlegroups.com>



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 Received on Fri Jul 15 2011 - 08:09:09 CDT

Original text of this message