I created a new Login called test. But when I connect using Management Studio.
I can connect to myDB database. But don't see the tables... I can see the system tables.
If I connect using sa - I can see ALL the objects.
What am I doing wrong. How can see the tables and using the test account?
What settings where do I need to set?