Re: how to prevent drop on a specific table

PMDORAIS_at_gmail.com wrote:
> HI, i'm not a big wiz with oracle but i would like to prevent dropping
> a specfic table only for all users.
>
> How can i do that?? ps. i use Oracle9i Enterprise Edition Release
> 9.2.0.5.0 .
>
>
> Thanks!!!!

There are code examples of how to prevent this with DDL Event Triggers in Morgan's Library at www.psoug.org. Look under DDL Event Triggers.

Also look at the same technique for preventing TRUNCATE and ALTER.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org