| drop table trace [message #138140] |
Tue, 20 September 2005 05:57  |
lijok
Messages: 68
Registered: April 2005
|
Member |
|
|
Hi,
Is there a way to find out the trace of the table being dropped from the schema. In the development environment all use the same user name to login. The trace should provide some clue (may be the IP address of the m/c from where the table was dropped) and time when it was deleted.
Thanks in advance
Regards,
Lijo
|
|
|
|
| Re: drop table trace [message #138146 is a reply to message #138140] |
Tue, 20 September 2005 06:48  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
You can perform some auditing.
set parameter
in your init.ora file.
then login as sys and run the command
AUDIT DROP TABLE
BY user_name
WHENEVER SUCCESSFUL;
And you can use few views like
AUD$, DBA_AUDIT_TRAIL, DBA_AUDIT_SESSION to view the information.
regards,
tarun
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
