RE: Making a table readonly?

From: Balakrishnan, Muru <Muru.Balakrishnan_at_echostar.com>
Date: Mon, 19 Sep 2005 12:17:40 -0600
Message-ID: <AF441DD9D86557429F06E975F01B2CC628C341@MER2-EXCHA4.echostar.com>

Raj, This is a good idea. It didn't strike to me. I will work on that and see the pros and cons. Thanks a lot!

Muru

-----Original Message-----

From: rjamya [mailto:rjamya_at_gmail.com]
Sent: Monday, September 19, 2005 12:12 PM To: Balakrishnan, Muru
Cc: Oracle Discussion List
Subject: Re: Making a table readonly?

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:20:06 CDT