| User script [message #319318] |
Fri, 09 May 2008 15:43  |
Daxesh
Messages: 60
Registered: September 2004 |
Member |
|
|
Hello,
Is there a way to find out what type of changes made in the database by particular user? When that change was made.
Any input would be appreciated.
Thanks..
[Updated on: Fri, 09 May 2008 15:49]
|
|
|
| Re: User script [message #319320 is a reply to message #319318 ] |
Fri, 09 May 2008 15:48  |
Michel Cadot
Messages: 15243
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
Use Log Miner to analyze the logs.
Regards
Michel
|
|
|
| Re: User script [message #319321 is a reply to message #319318 ] |
Fri, 09 May 2008 15:50 |
Daxesh
Messages: 60
Registered: September 2004 |
Member |
|
|
Can you tell me which log file should I read and where can I find that log file?
Thanks for your reply.. Any help would be appreciate..
|
|
|
| Re: User script [message #319322 is a reply to message #319321 ] |
Fri, 09 May 2008 15:54 |
Michel Cadot
Messages: 15243
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
Redo logs and archived logs.
v$log view
archive_log_dest% parameters
Regards
Michel
|
|
|
| Re: User script [message #319596 is a reply to message #319318 ] |
Mon, 12 May 2008 06:07 |
msmallya
Messages: 29
Registered: March 2008
Location: AHMEDABAD, GUJARAT |
Junior Member |
|
|
Also you can do value-based auditing. This you can achieve by writting triggers and store inofrmation needed to audit in a table.
Regards,
MSMallya
|
|
|
| Re: User script [message #319660 is a reply to message #319318 ] |
Mon, 12 May 2008 09:00 |
Daxesh
Messages: 60
Registered: September 2004 |
Member |
|
|
Do you have any script on this and willing to share with me?
Thanks..
|
|
|
| Re: User script [message #319667 is a reply to message #319322 ] |
Mon, 12 May 2008 09:32 |
Daxesh
Messages: 60
Registered: September 2004 |
Member |
|
|
Do you have any script to read v$log and archive_log_dest?
Thanks..
|
|
|
| Re: User script [message #319677 is a reply to message #319667 ] |
Mon, 12 May 2008 10:08 |
Michel Cadot
Messages: 15243
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
Did you make any search after our posts?
Regards
Michel
|
|
|
| Re: User script [message #319682 is a reply to message #319318 ] |
Mon, 12 May 2008 10:53 |
Daxesh
Messages: 60
Registered: September 2004 |
Member |
|
|
Yes but I could not find it. That's why I was asking that do you have any script?
Thanks..
|
|
|
| Re: User script [message #319684 is a reply to message #319682 ] |
Mon, 12 May 2008 10:57 |
anacedent
Messages: 5027
Registered: July 2005
Location: surf meets turf in SoCal |
Senior Member |
|
|
| Daxesh wrote on Mon, 12 May 2008 08:53 | Yes but I could not find it. That's why I was asking that do you have any script?
Thanks..
|
Are you claiming is that NONE of the Results 1 - 10 of about 307,000 for oracle v$log from GOOGLE answered your question?
How sad!
You can lead some folks to knowledge, but you can not make them think.
|
|
|
| Re: User script [message #319688 is a reply to message #319682 ] |
Mon, 12 May 2008 11:15 |
Michel Cadot
Messages: 15243
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
| Quote: | Yes but I could not find it.
|
So I can't help you, you'll have not the skills to understand my answer.
Regards
Michel
|
|
|
|
]
Members
Search
Help
Register
Login
Home
