Re: HELP: How can I find out how a table got deleted?

Neil Greene (ngreene_at_SHL.com) wrote:
: Wouldn't it be really cool if you could LOCK a table from delete. Or at least
: let it ask you "Are you sure?". Could you imagine some script being run by
: accident that nuked a bunch of your tables before you knew it. Sure, that
: might be why they call us DBAs, because we don't make that mistake. But, it
: can happen.
:

That's why (a) you should know if your code is potentially that destructive and (b) know how to do an export before testing it.

And of course, you have the ability to revoke the DELETE privilege from any user. (or role).

Joe

: -----
: Neil Greene
: Senior Oracle Database Adminstrator
: SHL Systemhouse, Inc. (PH) 714-562-4255 / (FAX) 714-562-5225
: LA Outsourcing Center Email: ngreeen_at_SHL.com [NeXT/Mime mail accepted]
:
: PS - I have never done this. Yet.
:
 

-- 
                                   
=------------------------------------------------------------------------=
Joe Nardone               |    
joe_at_access.digex.net      |