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 |
|
Mohan1975
Starting Member
1 Post |
 Posted - 2008-09-02 : 07:29:52
|
| Hi All Created Supervisor group in the Active Directory and added 4 person in that group. (AA,BB,CC,DD) - Windows Authentication users Later, I have Added AD group Supervisor under Server->Security->LoginsThis Supervisor group has db_owner and public database role Permission.Among these 4 person, 1 (AA) should have R/W person and rest should have Read Permission only.Please help me to implement when I am in this situation.Regards,Mohanraj Jayaraman |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2008-09-02 : 10:16:39
|
| You probrably need to add AA and BB as logins too.Then set up a ROLE then add AA and assign read permissions.Then set up a ROLE then add BB and assign r/wThats the only way i know how to do it....any ideas greatly appreciated. |
 |
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2008-09-02 : 16:08:10
|
| As far as i know,you can't implement like that.You can assign permissions either to the AD Group(All the members in this group will have same permissions) or you have to add individual logins and give the permissions.. |
|
|
|
|
|
|
Security Permission