Re: how to prevent drop on a specific table

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Fri, 23 Jun 2006 11:55:29 -0400
Message-ID: <9MCdnfnFoMVvkwHZnZ2dnUVZ_tudnZ2d@comcast.com>

<PMDORAIS_at_gmail.com> wrote in message
news:1151077592.992389.297330_at_u72g2000cwu.googlegroups.com...
: 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!!!!
:

the owner can drop the table

accounts with DROP ANY TABLE privilege can drop the table

IIRC that's it.

so, don't grant anyone DROP ANY TABLE

(however, the builti-in DBA role has that privilege)

what are you trying to accomplish/prevent? in what environments (tools)?

++ mcs Received on Fri Jun 23 2006 - 10:55:29 CDT