O'Reilly logo

Microsoft SQL Server 2014 Unleashed by Paul Bertucci, Alex T. Silverstein, Chris Gallelli, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

Image

FIGURE 15.7 The New User option in Object Explorer.

Figure 15.8 shows the 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 2014. In earlier versions, the Owned ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required