Re: Simple auditing question

From: Igor Neyman <igor.neyman_at_gmail.com>
Date: Mon, 6 Dec 2010 14:17:58 -0500
Message-ID: <AANLkTimVfqZMos3k0zY8+k5HsLiDbrQetCGTi2=syF-U_at_mail.gmail.com>

If you need to audit objects on database level, you'll have to write several triggers:

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_triggers.htm#CHDGIJDB

for each of ALTER/CREATE/DROP events, or just BEFORE (or AFTER) DDL trigger (same page in the docs).

Regards,
Igor Neyman

On Mon, Dec 6, 2010 at 1:48 PM, Dennis Williams < oracledba.williams_at_gmail.com> wrote:

> Thanks everyone for you great replies. As Mayen suggested, I checked
> further, and the requirement is to audit DDL statements, but not DML
> statements.
>
> Specifically we need to know how to audit DDL. I.E. ALTER TABLE, CREATE
> TABLE, DROP TABLE, CREATE INDEX, DROP INDEX, ALTER INDEX. Basically we need
> to audit all ALTERs, CREATEs, and DROPs on all objects in the database.
> Any thoughts on that score?
>
> Dennis Williams
> On Fri, Dec 3, 2010 at 2:06 PM, <Mayen.Shah_at_lazard.com> wrote:
>
>> Dennis,
>>
>> Rather than what you do not want to know (or what not to audit) you should
>> come up with the requirements of what you want to know or what you want to
>> audit.
>>
>> Best
>> - Mayen
>>
>>
>>
>>
>> From: "Dennis Williams" <oracledba.williams_at_gmail.com>
>> To: oracle-l_at_freelists.org
>> Date: 12/03/2010 02:45 PM
>> Subject: Simple auditing question
>> Sent by: oracle-l-bounce_at_freelists.org
>> ------------------------------
>>
>>
>>
>> List,
>>
>> I haven't used Oracle Auditing much, so this is probably a newbie
>> question. Need to turn on auditing for a high-volume OLTP database. My
>> understanding is that if I turn on AUDIT TABLE, it gets everything. I don't
>> need to know all the inserts, updates on these tables. Is there a simpler
>> audit setting? I probably am missing a concept.
>>
>> Thanks,
>> Dennis Williams
>>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Dec 06 2010 - 13:17:58 CST