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?