I'd like to leverage our Active Directory network groups to turn on and off visibility to certain areas of an application. Has anyone ever tried this? Any idea how to make it work?
Example:
Chart with item number and cost and selling price
User A has access to all 3 columns and has network group of QV_SeeCost
User B has access to item number and selling price ONLY and has network group QV_SeeApplication
I figure that there'll be a variable vShowCost = if network group = QV_SeeCost then 1 else 0. The column will be conditional on vShowCost = 1. How to I pull the network group from the user ID?
