User cannot see tables

Question

I've created an additional user in SQL Azure and set the permissions as dbmanager. This was all done in the master DB.

Now I have created another DB using the database administrator. When I'm logging in using the NEW user,  I can't see the tables from the Database see image .

New User's view - http://i45.tinypic.com/35lt7hh.png

Administrator view - http://i46.tinypic.com/2me8e92.png

Thanks appreciate your help. 

Answer 1

Your new user is a dbmanager. That's a role in the master database that lets you create databases. It doesn't give the user any permission once htey are inside another database. http://msdn.microsoft.com/en-us/library/windowsazure/ee336235.aspx

So grant some sort of permission to the new user in the new database such as GRANT SELECT ON DATABASE::newdb TO newuser;

---

Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty

Answer 2

OK thanks a lot.