Search This Blog

Wednesday, 10 October 2012

Assigning roles in Sql Server 2008 R2

Go to security => login tab of the security tab of  Sql server 2008 R2 right click and than select new login as u can see in the below image:


























Now click on the new login and than enter the login name as u can see in the image below:























Now click on the server roles and check the roles you want to assign to that user as you can see in the image below:
























Now click on the user mapping than check the database on which u have to assign the role related to that database and than select the checkboxes below which shows the roles related to selected database as you can see in the image below.























Now check the another database and than repeat the steps as I have stated above.

Thanks

Muhammad Zahid.



No comments:

Post a Comment