O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, 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

Understanding Roles

The first step in working with logins and users is to understand the roles available in SQL Database. This set of roles is distinctly smaller than what is available with standard SQL Server. In fact, there are only two roles you need to learn about:

Image dbmanager—Includes the permissions necessary to manage databases

Image loginmanager—Includes the permissions necessary to manage server logins and database users

These two roles are created in the master database when you set up your SQL Database server. You can view them by querying the ...

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