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: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
Date: Mon, 19 Sep 2005 11:12:41 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C45023615FB@NT15.oneneck.corp>


How does being in production prevent you from creating a read-only tablespace and moving the table there?

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

From: Balakrishnan, Muru [mailto:Muru.Balakrishnan_at_echostar.com] Sent: Monday, September 19, 2005 11:08 AM To: Khemmanivanh, Somckit; Allen, Brandon; Oracle Discussion List Subject: RE: Making a table readonly?

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!  

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

From: Khemmanivanh, Somckit [mailto:somckit.khemmanivanh_at_weyerhaeuser.com] Sent: Thursday, September 15, 2005 12:57 PM To: Brandon.Allen_at_OneNeck.com; Balakrishnan, Muru; Oracle Discussion List Subject: RE: Making a table readonly?  

Hmm, an external table that resides on read-only media?  

Thanks!    


From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Allen, Brandon Sent: Thursday, September 15, 2005 11:49 AM To: Muru.Balakrishnan_at_echostar.com; Oracle Discussion List Subject: RE: Making a table readonly?

One option - put it in its own tablespace and make the tablespace read-only.

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

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Balakrishnan, Muru Sent: Thursday, September 15, 2005 11:43 AM To: Oracle Discussion List
Subject: Making a table readonly?

Hello Gurus,  

How to make a table read-only (even table owner should not be able to insert, update or delete) if at all possible?  

TIA Muru  

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

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

Original text of this message

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