User script [message #319318] |
Fri, 09 May 2008 15:43 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Daxesh
Messages: 61 Registered: July 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] Report message to a moderator
|
|
|
|
Re: User script [message #319321 is a reply to message #319318] |
Fri, 09 May 2008 15:50 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Daxesh
Messages: 61 Registered: July 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 #319596 is a reply to message #319318] |
Mon, 12 May 2008 06:07 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
msmallya
Messages: 66 Registered: March 2008 Location: AHMEDABAD, GUJARAT
|
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
|
|
|
|
|
|
|
|
|
|
|