Probably a stupid question as I'm new at this but here goes:
I have a login for a group called 'Trials' that contains all members of my department. I need to assign specific users within the group permissions to different databases. For example, PersonA will have datareader permissions and PersonB will have datareader and datawriter permissions.
If I try this I get the message that the login already exists under a different name (unsurprisingly as it has been called PersonA). How do I give a group of users a login to the server but assign specific users within the group different permissions on the database? Do I need to add each one as an individual user login?