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?