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:
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 SQL Database server. You can view them by querying the ...