FGAC / EXEMPT and resulting Audit records – More explored

In my previous post I demonstrated, the potential for excessive audit record generation in Oracle 11g. In this post, I’ll explore the effect of a “Keyed function call” from view (or select statements) on generation of BY ACCESS audit records. I’ll use the same setup as described in the previous post for this demonstration too.… Read More FGAC / EXEMPT and resulting Audit records – More explored

Excessive AUDIT records with FGAC/EXEMPT privilege

Last week, I posted an article demonstrating the audit record generation with EXEMPT ACCESS POLICY in effect in Oracle 11g. In this article, I’ll demonstrate the potential for undesired audit record generation, due to in-effective audit configuration. Setup: 1.      User HR ownes the table T, as defined in my previous post. 2.      User A, FGAC… Read More Excessive AUDIT records with FGAC/EXEMPT privilege