Re: Oracle security question

Why not create a view that excludes the columns you wish to prevent access to and grant the SELECT on the view not the underlying table?

kshave_at_mbnet.mb.ca (Keith S.) wrote:

> Does anybody know if Oracle has any plans to allow you to restrict
>SELECT access on individual columns of a table? I am creating a new
>system and if I cannot restrict the SELECT access I will have to
>make some design changes (such as moving the secure columns to a
>separate table).
>
>
>--
>Keith Shave
>Management Information Services
>Ph: (204) 945-7937
>Fax: (204) 948-2542

To reply please remove the 'nospam' part of the address Received on Tue Oct 13 1998 - 16:11:29 CDT