Re: Column level security ?

You can use, for instance,
grant update (my_column) on my_table to the_user;

Columns can only be specified for privileges insert, update and references (i mean in versions 7, i don't know if it's the case in versions 8).

Ken Sproule a écrit dans le message <37b9d150.117033014_at_news.tds.net>...
>As always, I would like to thank in advance those who help.
>
>I assume in Oracle you can set permissions on an individual
>column.
>
>Does anyone know how I can restrict user access at the Column
>level?
>
>
>Thanks,
>
>Ken Sproule
>kenmn_at_tds.net
>
>
>Ken Sproule
>kenmn_at_tds.net
Received on Wed Aug 18 1999 - 02:25:33 CDT