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 14:11:43 -0400
Message-ID: <9177895d05091911112eac08e5@mail.gmail.com>


create a trigger on the table in question from sys account. In this trigger disallow insert/update/delete. Since the trigger will be owned by non-owner, it would be difficult to circumvent in normal circumstances.

Raj

On 9/19/05, Balakrishnan, Muru <Muru.Balakrishnan_at_echostar.com> wrote:
>
> The system is already in production, the options below are remote. I was
> trying to find out if there was another way that I was not aware of. Thanks
> to all of you for your time!
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Sep 19 2005 - 13:13:46 CDT

Original text of this message

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