Re: Column level security ?

From: Florin David <florind_at_earthlink.net>
Date: Thu, 19 Aug 1999 22:51:01 -0600
Message-ID: <37BCDEB5.733F356D@earthlink.net>

Create a view containing only the columns you want a certain group of users to see.
Create a role for that group and grant it select on the view but not on the underlying table.
Grant the role to each of the users in the group. Florin

Ken Sproule wrote:

> 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 Thu Aug 19 1999 - 23:51:01 CDT