Re: Column level security ?

From: Bob Swisshelm <swisshelm_at_lilly.com>
Date: 20 Aug 1999 13:07:00 GMT
Message-ID: <01beeb0f$cbab71c0$39309028@flintstone.d51.lilly.com>

To control SELECT access, you create a view that only contains the columns that you want them to see.

To control UPDATE and INSERT privileges, use the column name in the GRANT statement. For example

GRANT INSERT, UPDATE (ORDER_NO, DEST_STATE, ORDER_DATE) ON ORDERS TO SCOTT; DELETE access cannot be granted at a column level.

Bob
swisshelm_at_lilly.com

Ken Sproule <kenmn_at_tds.net> wrote in article <37bad16f.117063939_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 Fri Aug 20 1999 - 08:07:00 CDT