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

ekrem <nospam_at_dot.com> schrieb in im Newsbeitrag: 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.
>
> thanks in advance.
>
> cheers,
> ekrem

I know 2 ways to solve your problem:
1.
create a view on the table that contains only the columns that are updatable.
grant the update privilege only on the view and not on the table.

2.
create a "before update for each row trigger" , that sets (depending on the user) the :new value to the :old value for the columns that are not allowed to be changed.

hth
Jens (J.Meihoefer_at_BITS-on-the.net )
http://www.BITS-on-the.net Received on Wed Jun 14 2000 - 00:00:00 CDT