Providing appropriate permissions... [Resolved]

Posted by Jasminej under Sql Server on 9/18/2012 | Points: 10 | Views : 1566 | Status : [Member] | Replies : 4

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

0	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

0	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

0	Thank You Jasminej, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts