DouglasH (4/24/2014)
Are there any DENY permissions set on the user for the other schemas?If they try a SELECT query on one of the other schema tables (even though they can't 'see' them - I presume this is in SSMS) is there an error message returned?
dbo can't be blocked so this might explain why they can see the schemas when you add that in.
That is what I initially thought so I deleted the Users and Logins and I had the same problem.
I thought about trying to select. I have multiple users with only read permissions but I do not have this problem.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/