RE: Making a table readonly?
- From: "Balakrishnan, Muru" <Muru.Balakrishnan@xxxxxxxxxxxx>
- To: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>, "Khemmanivanh, Somckit" <somckit.khemmanivanh@xxxxxxxxxxxxxxxx>, "Oracle Discussion List" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 19 Sep 2005 12:15:50 -0600
To be more specific, technically its possible, but politically remote
:-)
-----Original Message-----
From: Allen, Brandon [mailto:Brandon.Allen@xxxxxxxxxxx]
Sent: Monday, September 19, 2005 12:13 PM
To: Balakrishnan, Muru; Khemmanivanh, Somckit; Oracle Discussion List
Subject: RE: Making a table readonly?
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@xxxxxxxxxxxx]
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@xxxxxxxxxxxxxxxx]
Sent: Thursday, September 15, 2005 12:57 PM
To: Brandon.Allen@xxxxxxxxxxx; 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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Allen, Brandon
Sent: Thursday, September 15, 2005 11:49 AM
To: Muru.Balakrishnan@xxxxxxxxxxxx; 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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]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.
Other related posts:
