Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Making a table readonly?

Re: Making a table readonly?

From: Scott Swank <scott.swank_at_gmail.com>
Date: Tue, 20 Sep 2005 08:25:49 -0700
Message-ID: <8ee6dd5c05092008253213597a@mail.gmail.com>


Definitely don't manage this by creating trigger(s). Oracle has already written code to manage access -- you don't need to. A read-only tablespace is a fine option, another would be to only grant select on the table. If necessary, create the table in a new schema, only grant select on it to the old schema owner (or public), drop the old table, and create a synonym in the old schema (or public) that points to the new table.

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 20 2005 - 10:28:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US