Re: audit alter table add column and drop column

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 04 Jan 2007 08:39:58 -0800
Message-ID: <1167928798.410849@bubbleator.drizzle.com>

aman.oracle.dba wrote:

> sybrandb wrote:

>> On Jan 3, 12:06 pm, "aman.oracle.dba" <aman.oracle...._at_gmail.com>
>> wrote:
>>> hi all,
>>> I can audit create table and drop table commands but I want to audit
>>> alter table command.
>>> basically I want to audit add columns and drop columns commands. Is it
>>> possible and if yes then how.
>> http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_48a.htm
>>
>> You could have done this yourself, couldn't you?

> First of understand my question. I want to audit alter table command
> with column name, which I was not able to do with audit command.
> Because alter any table for audit is there but it was not auditing.
> Check and then give suggestions.

>> Why do you continue to ask doc questions here?

> Check and then give suggestions.

>> Any reason (handicapped, blind, lazy) why you still don't do that, but
>> misuse this forum instead?
>>
>> --
>> Sybrand Bakker
>> Senior Oracle DBA

Use a DDL Trigger

You can build what you want by working from the demos in Morgan's Library at www.psoug.org (scroll down to DDL Triggers).

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Thu Jan 04 2007 - 10:39:58 CST