Microsoft® SQL Server 2012 Unleashed

Using SSMS to Manage Users

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 17.7 shows the Object Explorer window with the option to create a new user selected for the AdventureWorks2012 database.

FIGURE 17.7 The New User option in Object Explorer.

Figure 17.8 shows the new database dialog box that is displayed after you select the New User option. The New User dialog box has changed quite a bit in SQL Server 2012. In earlier versions, ...