Members   Search   Help    Register    Login   Home
Home » RDBMS Server » Security » user searching (10g )
user searching [message #425644] Sun, 11 October 2009 03:42 Go to next message
abdulahads
Messages: 11
Registered: October 2009
Location: SAUDI
Junior Member
A DML (Update) has been done on a particular table
need to find the username who has perform that
particular DML operation.

It's urgent please
Thanks in advance
Report message to a moderator
Re: user searching [message #425649 is a reply to message #425644] Sun, 11 October 2009 04:06 Go to previous messageGo to next message
Michel Cadot
Messages: 29432
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Use Log Miner.

Regards
Michel
Report message to a moderator
Re: user searching [message #425652 is a reply to message #425644] Sun, 11 October 2009 04:33 Go to previous messageGo to next message
Kamran Agayev
Messages: 76
Registered: February 2009
Location: Azerbaijan, Baku
Member
As Michel has suggested, either you need to use Log Miner to read archived redo log files or implement Oracle Audit to track all changes made to database
Report message to a moderator
Re: user searching [message #425692 is a reply to message #425644] Sun, 11 October 2009 22:06 Go to previous messageGo to next message
ebrian
Messages: 2714
Registered: April 2006
Senior Member
Depending on your undo settings, you may also be able to consider Flashback Transaction Query.
Report message to a moderator
Re: user searching [message #428944 is a reply to message #425644] Sat, 31 October 2009 01:19 Go to previous messageGo to next message
halim
Messages: 48
Registered: September 2008
Location: Bangladesh
Member
Write a trigger on that table to store it on a log table.


Regards
Halim
Report message to a moderator
Re: user searching [message #428952 is a reply to message #428944] Sat, 31 October 2009 01:58 Go to previous message
Michel Cadot
Messages: 29432
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
As it has been done IN THE PAST, creating a trigger NOW is useless.

Regards
Michel
Report message to a moderator
Previous Topic:Manage Large Number of Users
Next Topic:Transparent Data Encryption in Oracle 10g
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 1 03:27:29 CST 2009

Total time taken to generate the page: 0.33908 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.