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: