Azure SQL Server Configuration

purpose in azure sql server, similar to mssql, but with azure specific roles like ms serverstatereader the goal is to create a login and user with minimal read privileges grant permissions azure sql server create a server login create login \[ username ] with password = ’password ’; \ assign the serverstatereader role to allow viewing server state 5 alter server role ## ms serverstatereader ## add member \[ username ]; \ optionally , assign the definitionreader role for object definitions alter server role ## ms definitionreader ## add member \[ username ]; \ create a database user associated with the login create user \[ username ] from login \[ username ]; testing permissions connect as \[username] to the azure sql server and execute azure sql server select from sys dm os windows info ; if the query returns data, \[username] can view the server state, indicating that permissions are set up properly