Re: Make table read-only

From: Fabrizio <fabrizio.magni_at_mycontinent.com>
Date: Tue, 19 Oct 2004 15:40:29 GMT
Message-ID: <417140EB.9040601@mycontinent.com>

This is a trick I read while studying for OCP:

to make a table "read only" set a constraint to "DISABLE VALIDATE". No delete, update or insert will be permitted on that table. If there is no constraint you can create a "dummy" one.

Never tested but it should work.

Regards
Fabrizio

DA Morgan wrote:
> 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.
>
Received on Tue Oct 19 2004 - 10:40:29 CDT