Re: revoking a column

From: Dave Fowler <d.fowler_at_smmj.com>
Date: Mon, 30 Apr 2001 15:20:21 GMT
Message-ID: <VofH6.2099$G77.268283@newsread1.prod.itd.earthlink.net>

Mark,
this is a called user (your application) defined security. You want to secure certain rows with column values
from users or roles of users. If this is only this case needed, you could hard code some views that they would access data through.

hth
Dave Fowler

"Chirag (Mark) Patel" <patelc_at_mcss.cas.mcmaster.ca> wrote in message news:Pine.LNX.4.10.10104301034530.30204-100000_at_mcss.cas.mcmaster.ca...
>
> I would like to know if it is possible to revoke a spefic column in one of
> my Lookup Tables. For example, I have a lookup table with 4 codes (w/
> Description). One of the codes is "4" called "Task Tracking". I want to
> provoke certain users from having access to this option. Is it possible
> to revoke access to certain users where the code is equal to 4?
>
Received on Mon Apr 30 2001 - 10:20:21 CDT