A Common Username for Both Database hosted in Azure

by hiFI   Last Updated September 06, 2018 09:06 AM

I have 2 azure databases created in one SQL Server. I.e.

  1. Database 1 = db1 in xsqldb01.database.windows.net
  2. 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?

Related Questions

Add Active Directory User For Azure-SQL-DB

Updated February 25, 2017 13:06 PM