Oracle-L: Re: {SPAM?} Re: fine grained access

From: Pete Finnigan <oracle_list_at_peterfinnigan.demon.co.uk>
Date: Thu, 03 Jul 2003 10:34:24 -0800
Message-ID: <F001.005C33BC.20030703103424@fatcity.com>

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:pete_at_petefinnigan.com
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: oracle_list_at_peterfinnigan.demon.co.uk

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: ListGuru_at_fatcity.com (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). Received on Thu Jul 03 2003 - 13:34:24 CDT