Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: audit alter table add column and drop column

Re: audit alter table add column and drop column

From: aman.oracle.dba <aman.oracle.dba_at_gmail.com>
Date: 3 Jan 2007 22:13:08 -0800
Message-ID: <1167891187.416873.144510@q40g2000cwq.googlegroups.com>

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
Received on Thu Jan 04 2007 - 00:13:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US