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

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: 54125
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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: 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

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: 2786
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: 99
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: 54125
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

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: Sat May 18 10:48:12 CDT 2013

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