Re: problem with audit
Date: Thu, 8 May 2003 11:54:53 +0200
Message-ID: <1052387765.607614_at_tuxri2.tkcrij.ht.hr>
"Peter Grübl" <ibz.hotline_at_bmw.de> wrote in message
news:b9cqrd$c663_at_usenet.bmw.de...
> Hello
>
> I want to log every sql statment which is executed on a table including
> the complete statment text!
> I tried
> audit select, delete, insert, update on abc.tablename by access;
>
> but this doesn't return the full statment text in the dba_audit* views.
> Please help me
>
> best regards
> Peter
>
> --
>
> PGP encryption key 46CC3886
> available at http://www.keyserver.net
> Fingerprint = 8A4B 432D 0E5F D1B4 B33F 7C92 759E 67D6 46CC 3886
>
I think that your problem is in enabling auditing.
You have syntax AUDIT_TRAIL = value to enable or disable auditing.
For AUDIT_TRAIL value can be:
TRUE or DB Enables auditing
FALSE or NONE Disables auditing.
Also after enabling auditing you have many posibility what you want and what
you don't want to audit.
Robert
Received on Thu May 08 2003 - 11:54:53 CEST