Re: Make table read-only

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.
>
> Bye,
> Ralf

For the table owner ... No!

But if another schema ... just grant SELECT and don't grant any other object privilege.

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