Supported Databases and Databa...
Required Connection Permission...
Azure SQL Server Configuration
3 min
purpose in azure sql server, the goal is to create a login and user with minimal read privileges using azure specific roles like ms serverstatereader grant permission azure sql server create login \[ username ] with password = ’password ’; alter server role ## ms serverstatereader ## add member \[ username ]; create user \[ username ] from login \[ username ]; testing permission 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