update on ly one column

[naushi]

I have a table where I want the user to be able to select only coulmn 1,2 and 3 and be able to update only column 4.

Any idea how can I arrange permisisons. For the first one I have no problem since I can create a view for col 1,2 and 3. and give select permission on the view. What will I do for the col that has to be updated. Can we give update permission on a view?

Regards,
Naushi Hussain
Naushi.hussain@honeywell.com

 

[elam68]

hi,

The best way is grant the update priv on that column to partcular user. that will work.

elam

http://www.iteq.com.au