Subject Re: How to make a table read-only?
Author Adam
--- In, "russellbelding"
<russell@b...> wrote:
> I have some look-up tables I'd like to make read-only. One way to do
> this is to put before-update, before-insert, before-delete triggers
> on
> these tables and in the triggers place exceptions. Any suggestions of
> other ways to make a table a read-only-table?
> Thanks
> Russell Belding

Deny insert and update and delete permissions to the applicable users
or roles. (which may be everyone other than SYSDBA). Obviously someone
needs write permissions at some stage or the table will be empty.

There is also an option to make the entire database read only. But the
trigger option will also work.