Home » RDBMS Server » Security » how to find out
how to find out [message #160422] Sat, 25 February 2006 07:45 Go to next message
Messages: 107
Registered: May 2005
Location: Louisville
Senior Member

I have this production database where the audit_trail is set to 'DB'. One table was dropped accidentally. I need to find out who (the user id) dropped this table.

Using the TOAD tool I could find out when it was dropped (there is this feature called recycle binin TOAD which has the details of drop except the user ID).

Any help is greatly appreciated.
Re: how to find out [message #160860 is a reply to message #160422] Tue, 28 February 2006 15:06 Go to previous message
Frank Naude
Messages: 4571
Registered: April 1998
Senior Member
Check to see if you have any related records in sys.aud$.
Previous Topic: how to demobld in windows environment for a new user
Next Topic: user_ts_quotas shows removed tablespace info
Goto Forum:

Current Time: Sun Jul 03 09:39:29 CDT 2022