Re: Database Auditing

From: Mogens Nørgaard <mln_at_miracleas.dk>
Date: Tue, 10 Jun 2003 21:11:46 -0700
Message-ID: <F001.005AED4C.20030610205421@fatcity.com>

Hi,

It depends.

You can use triggers to do it (much easier with system triggers in 8i and onwards).

You can use FGA (Fine-Grained Audit) from 9i onwards.

If you just want to know how much DML is taking place aginst which tables you can use the monitoring facility in 8i onwards, which will flush data about inserts, deletes and updates to the dictionary every 3 hours (8i) or every 15 minutes (9i). Thanks to the guys at the UKOUG meeting in Birmingham recently for pointing this out (forget who it was, unfortunately).

Mogens

Basavaraja, Ravindra wrote:

Hi All,

How do we turn on statement level auditing (DB and OS Level) to audit the DML/DDL's on the database.Is this possible with out triggers?

Thanks

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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). Received on Tue Jun 10 2003 - 23:11:46 CDT