Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to prevent drop on a specific table

Re: how to prevent drop on a specific table

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 23 Jun 2006 18:04:46 +0200
Message-ID: <j84o92d6ck7866lejsahu8v6ud1lgra8e7@4ax.com> 





On 23 Jun 2006 08:46:39 -0700, 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!!!!





DDL trigger.


--
Sybrand Bakker, Senior Oracle DBA


Received on Fri Jun 23 2006 - 11:04:46 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US