|
|
Posted by Erland Sommarskog on 10/13/31 11:31
(gregory.sharrow@usa.net) writes:
> So let say I have a user 5 who has access to
> products in (10,11)
> or
> customers in (20,21,22)
> or
> salesreps in (1)
>
> How would I populate the cross ref table?
Do you mean that this have the rights to see a row as long as any
of these conditions are fulfilled? Then you would enter six rows,
all with a different groupcode. The group codes are there when you have
AND conditions like "User may only see the combination of salesrep = 2
and customer = 29".
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|