Re: Read only access to a table except for some fields

"ekrem" <nospam_at_dot.com> wrote in message news:GiG15.20626$c5.35519_at_newsfeeds.bigpond.com...
> how do I give an oracle (8.15i) user read only access to a table *except*
> for a couple fields within that table which the user has to be able
> to change the values.
>

Views are the way to go, although you can grant object privileges (such as select or update) on portions of a table (eg, grant update(name, bank_details) on emp to Bill).

Horribly specific, but it will do the trick.

Regards
HJR
> thanks in advance.
>
> cheers,
> ekrem
>
>
Received on Wed Jun 14 2000 - 00:00:00 CDT