OraFAQ Forum: Security » user searching

Home » RDBMS Server » Security » user searching (10g )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

user searching [message #425644]

Sun, 11 October 2009 03:42

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

Michel Cadot
Messages: 67640
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

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