Home » RDBMS Server » Security » Oracle audit trail
Oracle audit trail [message #19828] Thu, 11 April 2002 09:31 Go to next message
Dave
Messages: 92
Registered: August 1999
Member
Hi there,

I need to urgently find out who updated some oracle tables on a particular day, I know what data was changed but I need to find out who made the change. Is this information somewhere in the DB and how can I retrive it.

Thanks in advance,
Dave

Report message to a moderator

Re: Oracle audit trail [message #19832 is a reply to message #19828] Thu, 11 April 2002 17:57 Go to previous message
seng
Messages: 191
Registered: February 2002
Senior Member
Use Audit Trail(enable with audit_trail = OS/DB/NONE) or LogManer to process logfile/archived file. For more information, please refer to Oracle Document. Hope this is helping.

Report message to a moderator

Previous Topic: revoke create table does not work for dba - Urgent
Next Topic: encrypt/decrypt password field in a user defined table for oracle 8i release 8.1.5
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 23:58:26 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.