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: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
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: 2794
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: 100
Registered: September 2008
Senior 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: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
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: Mon Sep 22 16:31:42 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.