Re: Oracle security question

From: Thierry Poels <PoelsT_at_DMA.BE>
Date: Wed, 14 Oct 1998 09:54:58 +0200
Message-ID: <701rsh$qqi$1@news1.skynet.be>

Hi,

You can only grant insert, update and reference for specific columns. Other priviliges, like select, delete, ..., are all based on all columns.

Like "TurkBear" already said, you can solve this by defining a view which only shows the columns you want, and ONLY grant select on the view, and not on the table.

greetings,
Thierry Poels
DBA & Unix System Manager for VTB-VAB
http://www.vab.be/

Keith S. wrote in message ...
> 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
Received on Wed Oct 14 1998 - 02:54:58 CDT