| Row-level auditing [message #254510] |
Fri, 27 July 2007 00:26  |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
I've been looking at auditing and fine-grained auditing, and it seems that the lowest level of auditing supported is at the STATEMENT level.
Is this right? Is it possible to perform ROW LEVEL auditing on a table?
We have a regulatory requirement to load a privacy database with a log record per accessed row. This seems unlikely and non-scalable to me, as a full-table-scanwould load the entire table into the privacy database. Scary!
Ross Leishman
|
|
|
|
|
|
| Re: Row-level auditing [message #254809 is a reply to message #254695] |
Sat, 28 July 2007 08:18  |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
But I think that "row level" is misleading.
My understanding is that you can TARGET an individual row for auditing, so that if a statement acts upon that row, the statement is audited.
When a statement is audited, I want to know all of the rows that it hit.
To put it another way, FGA appears only to create at most one audit row per audit policy per statement. I want many audit rows per audit policy per statement.
Ross Leishman
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
