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: rjamya <rjamya_at_gmail.com>
Date: Mon, 19 Sep 2005 15:00:56 -0400
Message-ID: <9177895d0509191200742061be@mail.gmail.com>


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.

Raj

On 9/19/05, Gogala, Mladen <MGogala_at_allegientsystems.com> wrote:
>
> Trigger would look something like this:
>

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

Original text of this message

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