Providing appropriate permissions... [Resolved]

Posted by Jasminej under Sql Server on 9/18/2012 | Points: 10 | Views : 953 | Status : [Member] | Replies : 4
In our Team, we have 15 members (2 are Testers, 8 are Developers, 1 is Business Analyst, 4 are Senior developers)

So, We are planing to provide permissions for each members in our team...(for all 15 members)

So, What would be the best way to implement this process ?

I need detailed explanation with example on each steps. But, Please don't post any links.... :)

Thanks in advance




Responses

Posted by: Pandians on: 9/19/2012 [Member] [MVP] Silver | Points: 50

Up
0
Down

Resolved
Ok.

Creating Server Role is not possible in SQL Server 2008 R2. This provision has been given in SQL Server "Denaly" version onwards..

So, You can proceed with the following way!

1. Create Database Role for each Group (Tester, Developer, BA, SDeveloper) in each databases.
2. Create Login for each individual members (15 Members)
3. Map the Login for each Database
4. Map each role with each Login
5. Grant permission for each Role what ever you want!

I hope it would help you!

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Jasminej, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Pandians on: 9/18/2012 [Member] [MVP] Silver | Points: 25

Up
0
Down
What Edition/Version of SQL Server you are using ?

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Jasminej, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jasminej on: 9/18/2012 [Member] Starter | Points: 25

Up
0
Down
We are using sql server 2008 R2 Standard edition

thanks for your reply!

Jasminej, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jasminej on: 9/20/2012 [Member] Starter | Points: 25

Up
0
Down
Thank You

Jasminej, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response