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 insert, delete, update on sys.aud$

Re: audit insert, delete, update on sys.aud$

From: <premmehrotra_at_hotmail.com>
Date: 31 Mar 2005 16:19:20 -0800
Message-ID: <1112314760.277808.151450@l41g2000cwc.googlegroups.com>

Anurag Varma wrote:
> Prem,
>
> Thinking aloud:
> If audit ... audited insert on sys.aud$ table which would cause a
> record to be inserted into the sys.aud$ table ..
> then don't you think that would cause an endless inserts to happen
> on the sys.aud$ table?
>
> Anurag

Anurag:

Thanks.

It does make sense, I wish Oracle did not allow following statement:

audit insert on sys.aud$

It is probably too much work for Oracle SQL engine to do this kind of syntax checking.

Prem Received on Thu Mar 31 2005 - 18:19:20 CST

Original text of this message

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