Posted by Erland Sommarskog on 12/05/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

[Back to original message]