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

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.

Report message to a moderator

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: 4581
Registered: April 1998
Senior Member
Check to see if you have any related records in sys.aud$.

Report message to a moderator

Previous Topic: how to demobld in windows environment for a new user
Next Topic: user_ts_quotas shows removed tablespace info
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 11 20:15:16 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.