Understanding Roles
The first step in working with logins and users is to understand the roles available in ASD. 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:
dbmanager—Includes the permissions necessary to manage databases
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 ASD server. You can view them by querying the system view sys.database_principals ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
