Re: Table security question

From: <satar_at_my-dejanews.com>
Date: Fri, 18 Sep 1998 21:48:58 GMT
Message-ID: <6tukgb$odu$1@nnrp1.dejanews.com>

You can create a view: CREATE VIEW "DUMMY".dope AS select col1, col2, col5 from table ass WITH READ ONLY; Then grant select privilages to the view... or another option is to create a snapshot of the table.

Good Luck,
Satar Naghshineh

In article <VmyM1.342$jD5.616441_at_typhoon.mbnet.mb.ca>, kshave_at_mbnet.mb.ca (Keith S.) wrote:
> I have a table with several columns in it. For example ...
>
> TABLE a
> col 1
> col 2
> col 3
> col 4
> col 5
>
> I want to give read access to the table, but only to columns 1,2 and
> 5. By granting 'SELECT' access on the table I would allow the user to
> view all of the columns.
>
> Besides separating columns 3 and 4 out into a separate table and
> assigning appropriate access there, is there any way to restrict the
> access to these columns but still give read access to the rest of the
> columns?
>
> --
> Keith Shave
> Management Information Services
> Ph: (204) 945-7937
> Fax: (204) 948-2542
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Sep 18 1998 - 16:48:58 CDT