Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dumps
Starting Member
10 Posts |
 Posted - 2010-01-13 : 10:38:30
|
| Hi,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?Thanks |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-01-13 : 10:40:02
|
| Do you mean an Active Directory Group ?Jack Vamvas--------------------http://www.ITjobfeed.com |
 |
|
|
Dumps
Starting Member
10 Posts |
Posted - 2010-01-13 : 10:46:39
|
| Yes, its a windows network |
|
|
|
|
|
|
Logins and users