AnsweredAssumed Answered

Multiple Privilege Sets Under One Login

Question asked by asoria on Dec 12, 2016
Latest reply on Dec 16, 2016 by philmodjunk

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?


For example:

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!