RE: Making a table readonly?

From: Gogala, Mladen <MGogala_at_allegientsystems.com>
Date: Mon, 19 Sep 2005 15:10:15 -0400
Message-ID: <A2C7821363A0544987988F6BCCE941B506082A@pegasus.lawaudit.com>

Of course, things that do not write to the table, like truncate, will still be permitted.

One little "truncate table" is nothing to be worried about as it will not modify the data.

Mladen Gogala

Ext. 121

From: rjamya [mailto:rjamya_at_gmail.com]
Sent: Monday, September 19, 2005 3:01 PM To: Gogala, Mladen
Cc: oracle-l_at_freelists.org
Subject: Re: Making a table readonly?

Yup, the key is to own that trigger by sys, so table owner won't go, disable the trigger and mess with data. Along with this, you should however incorporate auditing on this table to capture anyones attempts to mess with data.

--

http://www.freelists.org/webpage/oracle-l Received on Mon Sep 19 2005 - 14:12:20 CDT