Re: Make columns read only

From: Gerard H. Pille <ghp_at_skynet.be>
Date: Tue, 09 Nov 2010 21:23:12 +0100
Message-ID: <4cd9adaf$0$14258$ba620e4c_at_news.skynet.be>



Mark D Powell wrote:
>
> To add to what has already been suggested.
>
> If you do not want certain columns in a table updated by most users
> then those users should not have update privilege on the table to
> begin with. You can use views and/or stored code to provide read
> access and update access.
>
> Also on 10g+ you can restrict column access via virtual private
> database (VPD).
>
> Combing VPD with views and stored procedures can do a lot to protect
> data.
>
> HTH -- Mark D Powell --

Why would you waste performance that way, iso only granting update on selective columns? Received on Tue Nov 09 2010 - 14:23:12 CST

Original text of this message