Hi Peter, If you only want to know that the table was accessed with a select and not the details at row level then you can use regular audit. It sounds like you want to capture explicit selects though at row level so you should look at using fine grained audit. I am not aware of any other way to record read access at the row level other than esoteric solutions that involve reading SQL*net packets or inserting a layer in OCI to be able to grab the SQL statements at source. A more workable solution would involve you parsing SQL from the SGA regularly but all this is overkill when fine grained audit will do exactly what you want.
kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
