kweiskittel (9/6/2016)
Eric, Did you see my first post right before yours? How do you explain that? Very odd yes?It's the same SQL account; one user can see the tables, the other user cannot. I don't think it's related to permissions, etc. I've never had to explicitly set permissions for a public user to merely see tables, especially when they have the db_datareader permissions.
Kris
OK, apparenting some of you are experiencing an issue where two users with the same permissions, perhaps even the same login account, are seeing different objects displayed in SSMS. It would be interesting to run a SQL Profiler trace on all T-SQL events to capture what differences there are in system schema queries while each user navigates the database in SSMS.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho