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: Lock Table

Re: Lock Table

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 17 Jun 2005 07:35:01 -0700
Message-ID: <1119018910.945366@yasure>


Maxim Demenko wrote:
> daniellopez21 schrieb:
>

>> How I can block a table, so that this is of read-only even for the
>> owner user? And that cannot be drop table, without having to use
>> trigers
>> Thanks
>>

>
> You should put this table in read only tablespace ( still possible to
> drop it - may be prevented by use of ddl triggers)
>
> Best regards
>
> Maxim

And for demos of DDL triggers go to:
http://www.psoug.org
click on Morgan's Library
click on DDL Triggers

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Fri Jun 17 2005 - 09:35:01 CDT

Original text of this message

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