Re: Make table read-only

In article <7n57n0t979rtkrvpcploqj7u37fqk9k6gu_at_4ax.com>, Ralf Zwanziger <ralf_on_duty_at_gmx.de> writes
>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
>

Hi,

There has been some good ideas in this thread and I agree with Howard's comments that we need to know the complete requirements for the OP's read only table in terms of how long it needs to be read-only.

In the meantime to throw another idea into the fray to make the table read-only is to use Row Level Security to prevent any DML being successful. Again as with triggers and table locks its just as easy for a user with the correct privileges to disable the policies again. The problem also is that privileged connections are exempt from the policies created and its an extra cost option. Whether its of use depends on your requirements.

kind regards

Pete

-- 
Pete Finnigan (email:pete_at_petefinnigan.com)
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Oracle security blog: http://www.petefinnigan.com/weblog/entries/index.html
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.