A Common Username for Both Database hosted in Azure I have 2 azure databases created in one SQL Server. I.e.


Database 1 = db1 in xsqldb01.database.windows.net
Database 2 = db2 in xsqldb01.database.windows.net


I would like to create a username or user login where I can read only data (Select grant only) of both databases. How can I achieve this? Do I need to create a user login with same name in both database?
You can create Login in master database using syntax ..

CREATE LOGIN &lt;SQL_login_name, sysname, login_name&gt; 
    WITH PASSWORD = '&lt;password, sysname, Change_Password&gt;' 
GO


and then create user in individual databases using syntax

CREATE USER &lt;user_name, sysname, user_name&gt;
    FOR LOGIN &lt;login_name, sysname, login_name&gt;
    WITH DEFAULT_SCHEMA = &lt;default_schema, sysname, dbo&gt;
GO

GRANT SELECT  TO &lt;user_name&gt;


This can be done via SSMS from local machine or VM. I believe you can achieve this using Query Editor in Azure as it does not allow switching context to master database .