This content has been marked as final. Show 2 replies
Unfortunately, Capture Rules are "all or nothing". You can control the scope - Global, Schema, or Table, and you can control the type of activity - DDL or DML, but nothing else. FGA policies are a completely separate mechanism for auditing activity conditionally. However, they do not make use of the REDO log mechanism that Streams does. FGA policies do give you the ability to create audit records when certain conditions occur, such as the application context containing specific user information. They also give you the ability to capture SQL Text and SQL Bind data. They do not, however, give you before / after values.
If you define both an FGA policy and a Capture Rule on a table, you will get two or more records (one from FGA_LOG$ using the DBAUD collector, and one or more from the REDO log - one for each affected row, using the REDO collector).
Hope this helps.