Re: problem with audit

Hallo

Thank you for your response. My audit_trail value is db. I get audit information but the problem is that I don't get the whole sql statement.

bye
Peter

Robert Dimitrovski wrote:

>"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
>
>
>
>
 

-- 


BMW IBZ Hotline                                        
Heidemannstr. 170                                      
80807 München                                          
Tel. +049 89 382 47588    
                             
PGP encryption key 46CC3886
available at http://www.keyserver.net
Fingerprint = 8A4B 432D 0E5F D1B4 B33F 7C92 759E 67D6 46CC 3886