Running the CREATE ROLE statement in master database as server-level principal gives:

Msg 15247, Level 16, State 1, Server NNN, Line 10
User does not have permission to perform this action.

Running the same statement in user database succeeds. Is there a way to create a role in master database in SQL Database?

• Edited by Martin Rakhmanov TW Tuesday, February 17, 2015 8:35 PM

Hi Martin,

Thanks for reaching out. It is not possible to create roles in the logical master in SQL database. Some more information on user management in SQL database can be found here: https://msdn.microsoft.com/en-us/library/azure/ee336235.aspx

Thanks,

Jan

• Proposed as answer by Joseph IdziorekMicrosoft employee Wednesday, February 18, 2015 10:30 PM