September 2010
Intermediate to advanced
1704 pages
111h 8m
English
To manage users via SSMS, you open the Object Explorer and expand the Security node followed by the Users node. The Users node contains a list of the current database users. To add a new database user, you can right-click the Users node and select New User. Figure 11.7 shows the Object Explorer window with the option to create a new user selected for the AdventureWorks2008 database.
Figure 11.7 The New User option in Object Explorer.

Figure 11.8 shows the new database user screen displayed after you select the New User option. In this figure, a login named Chris is used, and the database user name is Chris as well. ...