Home » RDBMS Server » Server Administration » USER ID FETCHING (10G)
USER ID FETCHING [message #524228] Thu, 22 September 2011 05:32 Go to next message
db_learner
Messages: 5
Registered: September 2011
Junior Member
Hi,

In my project a user has updated a column with wrong value which had caused some issues.
I wish to find the userid of person who did the update on the table.
There is no trigger on that table

I used the following queries but have not got success

select * from USER_TAB_modifications where table_name like '%XYZ%';

select * from USER_AUDIT_OBJECT ;

I WAS ABLE TO GET WHEN LAST UPDATE TOOK PLACE on table but not userid details
Please guide for the same.

Report message to a moderator

Re: USER ID FETCHING [message #524234 is a reply to message #524228] Thu, 22 September 2011 05:46 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
If you have no audit then you can try:
1/ If it is not too far ago: flashback transaction query
2/ Else Log Miner

(Both are searchable on the documentation)

Regards
Michel

Report message to a moderator

Previous Topic: What will be the fastest way to move a db data to another db(has data)?
Next Topic: dbua
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 04:40:31 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.