I have a table that acts as a security filter so that one user can't access another's data with thier automatic logged in credentials. I'm using a dynamic parameter to shorten the list of choices for each user group and they have to select their user group in order to display the correct choices.
I'm wondering if anyone has played around with a SQL query that would return only the user groups the user has access to.
Example: frank is in user group A which can choose X,Y, or Z
Bob is in user group B which can choose N,M, or L
How do I set the parameter so they are not required to select a or b?
IP Logged
