Re: Make table read-only

Mark C. Stock wrote:

> "Mladen Gogala" <gogala_at_sbcglobal.net> wrote in message
> news:pan.2004.10.18.11.41.13.193031_at_sbcglobal.net...
> | On Mon, 18 Oct 2004 12:12:57 +0200, Ralf Zwanziger wrote:
> |
> | > Is ist possible to make an oracle table read-only?
> | > (without moving it to a read-only tablespace).
> | > I haven't found any command like "alter table xxx read only" in the
> | > docs.
> |
> | "Truncate table" will prevent users from updating any row in the table.
> | It will not prevent inserts.
> |
> | --
> | Artificial Intelligence is no match for natural stupidity.
> |
>
> Mladen, I sure hope you're not serious...
>
> TRUNCATE TABLE is as command, not a privilege, and it will prevent users
> from reading any data in the table, because it deletes all rows -- and
> afterwards inserts (by users with INSERT privileges) are not only allowed,
> but many, many, many will be necessary to restore the data destroyed by the
> TRUNCATE TABLE command!
>
> ++ mcs

And whether serious or not I would suggest that such suggestions NEVER be made as it is quite possible that some newbie or lurker might actually try it not realizing the impact.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)