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.
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