Is there a way to allow multiple privilege sets for one login? We have multiple "locations" in one database, and managers and supervisors may only access the location they are assigned to. The problem is that we have some managers that need to be able to access multiple locations. We have a data table where I assign the location they may access, but if I try to add more than one it defaults to only allow access to the first one chosen. What are we doing wrong? Is there a better way to do what we want?
Login1- only access to Location A
Login2- only access to Location B
Login3- needs access to Location A and B
To get around it, we've created Login3 for A, and Login3B for access to B... but I'd really like to figure out how to give access under just one login.
Thank you in advance for your help!