I've done the following on my SQL Azure instance:
1) Add a new login
2) Create a new user on my database from that login
3) Granted db_datareader to that user on that database
I can use that user to connect through SQL Server Management Studio, and I can expand the "Databases" node in the Object Explorer, but once I try to right-click the database to select "New query", the whole UI freezes for about 30 seconds.
I can connect and do the same thing with the db_owner, and it works without a problem.
Is there some other role/right I have to give to the user?
Best Answer
Please run the following statement on the Master database and that should do the trick
CREATE USER LoginName FROM LOGIN LoginName
Hope this helps.
Regards,
Alberto Morillo