I have 2 azure databases created in one SQL Server. I.e.
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?