Re: READ-ONLY Tables and Views

In article aco_at_sol.zynet.net, Ellard_at_DMLIS.zynet.co.uk (Ross Ellard) writes:
>
> I have a vague recollection that a note was posted in this newsgroup a
> few months ago talking about an undocumented SQL extension to the
> CREATE TABLE or CREATE VIEW command that made the respective object
> READ-ONLY.
>
> We have a need to create both types of objects as READ_ONLY objects so
> can anybody remind me of the original posting?
>
> Ross Ellard
>

Hello,

You can make the tablespace in which the table is residing READ-ONLY by alter tablespace ... command. Indirectly the tables are also made READ-ONLY.

Thanks,

Ravi. Sun MicroSYSTEMS, Inc. dba_temp1_at_nika.ebay.sun.com Received on Fri Jan 19 1996 - 00:00:00 CET