Page Comparison

...

1. To add a user to a database role:
2. Run SQL Server Management Studio from the desktop or Start > Programs > Microsoft SQL Server.
   
   The Connect to Server window is displayed.
   
3. Enter the login details for the server running SQL Server.
4. Click Connect Image Added.
   The Microsoft SQL Server Management Studio window is displayed.
   
5. Select View > Object Explorer, if Object Explorer is not already displayed.
   
   The Object Explorer pane is displayed on the left-hand side of the window.
   
6. Drill into the following by clicking the plus sign next to:
   
   • [+] Microsoft SQL Servers
   • [+] SQL Server Group
   • [+]  (Your Server Name)
   • [+] Security
   • [+] Database roles.
   
   
7. Right-click the database role you want to add the user to. You can click:
   
   • publicfinance
   • public{ExtraFinanceDBName}.
   
   
8. Select Properties.
   
   The Database Role Properties window is displayed.
   
9. Click Add....
   The Select Database User or Role window is displayed.
   
10. Type the name of the user into the Enter the object names to select field.
11. Click Check Names.
12. Click .
13. Repeat steps 3 through 11 to add additional users to database roles.
14. Save the changes.

...