Home » RDBMS Server » Server Administration » Logs
Logs [message #58396] Fri, 22 August 2003 23:59 Go to next message
Hasan Mannan
Messages: 5
Registered: November 2002
Junior Member
Dear friends,
some user did changing in my database..I want to know which user did this and with which tables he did modifications.
Is there any log file that stors this information...
Thankx in advance
Hasan.

Report message to a moderator

Re: Logs [message #58398 is a reply to message #58396] Sat, 23 August 2003 15:23 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
nope.
unless you turn auditing on, it is not possible to trace the user activities

Report message to a moderator

Re: Logs [message #58399 is a reply to message #58396] Sat, 23 August 2003 21:47 Go to previous message
ctg
Messages: 146
Registered: July 2002
Senior Member
If you are using 8i or above, you can use Logminer Utility (through oracle supplied PL/SQL package DBMS_LOGMNR) to analyze the Archived Redo Logs (if you have them) and your online redo logs.

Report message to a moderator

Previous Topic: Temporary Segments
Next Topic: statspack
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 09:43:18 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.