Re: Make table read-only

"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 Received on Mon Oct 18 2004 - 07:16:22 CDT