Creating Users in Azure SQL
I am not an SQL DBA by any stretch of the imagination, so some tasks have taken a bit of Googling to conquer!
There are some key differences between a full SQL install and Azure SQL. One of the main differences with Azure SQL Azure PaaS databases is that you need to do so much more through Transact-SQL. My limited experience of SQL has all been based through GUI prompts, so this initially proved a problem for me.
One of the tasks which I have had to complete a fair amount recently is to create database users. In the Azure Portal you can create administrator accounts for the whole server, but this doesn't match the requirements of the business in most occasions.
I came across these blog posts on the Microsoft website
So to create a read-only user for a single database, the Transact-SQL you need are
Now....when a user tries to connect with this account, they will most likely get this error.
Alternatively, you can inform the user to type in the specific database in the options of SQL Studio