Home » RDBMS Server » Security » user searching (10g )
user searching [message #425644] Sun, 11 October 2009 03:42 Go to next message
abdulahads
Messages: 44
Registered: October 2009
Location: SAUDI
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
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: 58616
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use Log Miner.

Regards
Michel
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: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior 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
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: 2794
Registered: April 2006
Senior Member
Depending on your undo settings, you may also be able to consider Flashback Transaction Query.
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: 99
Registered: September 2008
Location: Bangladesh
Member

Write a trigger on that table to store it on a log table.


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

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


Current Time: Wed Jul 30 02:48:55 CDT 2014

Total time taken to generate the page: 0.13401 seconds