RE: Making a table readonly?

  • From: "Balakrishnan, Muru" <Muru.Balakrishnan@xxxxxxxxxxxx>
  • To: <rjamya@xxxxxxxxx>
  • Date: Mon, 19 Sep 2005 12:17:40 -0600

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@xxxxxxxxx] 
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@xxxxxxxxxxxx> 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!

Other related posts: