which OS user has dropped the objects [message #318264] |
Tue, 06 May 2008 05:12  |
manoj12
Messages: 210 Registered: March 2008 Location: India
|
Senior Member |
|
|
Dear Sir
could you please tell me the script which will give me the OSUSER and the action performed by him on a particular day.I know v$session is the view which will give us the information about the user and the action performed by him.
Suppose I have dropped 10 tables(i.e objects) on a particular day.Can I find which user has dropped 10 tables on that particular day,.
Any query will help me to solve my problem.?
Thanks..
|
|
|
Re: which OS user has dropped the objects [message #318269 is a reply to message #318264] |
Tue, 06 May 2008 05:29   |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
If you've got Auditing enabled, then you can get this information.
If you've written some triggers that fire on the appropriate DROP event, then you can get this information.
Otherwise, I think you're out of luck.
|
|
|
|
|
|
Re: which OS user has dropped the objects [message #318276 is a reply to message #318271] |
Tue, 06 May 2008 05:46   |
manoj12
Messages: 210 Registered: March 2008 Location: India
|
Senior Member |
|
|
Dear sir
Thank you....
As you said that you can use log miner which will give me the information as to when did i dropped the objects.
Suppose I as a user have dropped 10 objects on 01-May-08 time and today is 06-May-08.Will log miner tool be helpful for showing the audit of 01-may-08?Will it be showing the time also as to what is the exact time I have dropped the particular objects on 01-May-08?
Regards
|
|
|
|
Re: which OS user has dropped the objects [message #318279 is a reply to message #318277] |
Tue, 06 May 2008 06:04   |
manoj12
Messages: 210 Registered: March 2008 Location: India
|
Senior Member |
|
|
Dear Sir
One last question I would like to ask in order to start logminer I need to create a dictionary file .After creating the dictionary file using the build procedure I need to add logs using the DBMS_LOGMNR package. Then I need to start the logminer which will give me the logs using the DBMS_LOGMNR.start_logmnr but what should be the value of startscn and the stopscn should be it should be 100 and 150 or any default value?..
Regards
[Updated on: Tue, 06 May 2008 06:05] Report message to a moderator
|
|
|
|
|