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
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.
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:
  


Current Time: Thu May 26 16:14:14 CDT 2022