Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Making a table readonly?
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-lReceived on Tue Sep 20 2005 - 10:28:06 CDT
![]() |
![]() |