|
|
| Author |
Message |
Surya Kira nPasumarthi
New User
Joined: 21 Nov 2007 Posts: 10 Location: hyderabad
|
|
|
|
Hi,
I have table tvb2.vpm_policy and all the data in that particular table of that schema is deleted..how to know who has deleted and when it has been deleted |
|
| Back to top |
|
 |
References
|
Posted: Thu Apr 17, 2008 1:36 pm Post subject: Re: Rows deleted...how to know who deleted!! |
 |
|
|
 |
shrivatsa
Active User
Joined: 17 Mar 2006 Posts: 157 Location: Pune
|
|
|
|
If you have
6 LOG Analysis - Who Updated My Table
in your shop then you can do it.
Otherwise contact DBA they will do an AUDIT. |
|
| Back to top |
|
 |
rajesh_m
New User
Joined: 15 Apr 2008 Posts: 36 Location: India
|
|
|
|
Hi shrivatsa,
| shrivatsa wrote: |
If you have
6 LOG Analysis - Who Updated My Table
in your shop then you can do it.
|
Can u please breif me regarding 6 log analysis and how can i ensure that it is in my shop. |
|
| Back to top |
|
 |
dick scherrer
Global Moderator
Joined: 23 Nov 2006 Posts: 7505 Location: 221 B Baker St
|
|
|
|
Hello,
Ask your dba what is available on your system. |
|
| Back to top |
|
 |
|
|