Users can't see tables part of a schema in SSMS

Question

Post reply

Users can't see tables part of a schema in SSMS

DBAgal

Hall of Fame

Points: 3185
More actions
March 9, 2009 at 8:48 am

#197892

Hi all -
I'm having a problem getting tables part of a particular schema to show up in SSMS. I have granted the users "Select" and "View Definition" rights to both the schema and the four tables within the schema. They can now perform selects on the tables, but only if they know the exact name of the table, as they do not show up under DatabaseName >> Tables in SSMS.
I'm out of ideas.
Thanks in advance for your help.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

david_wendelken SSCrazy Points: 2388 More actions · Answer 1

Hi,

We just had the same problem show up today, but with views instead of tables.

Did you ever find a fix?

DBAgal Hall of Fame Points: 3185 More actions · Answer 2

I think I granted "View Definition" privileges at the database level.

Right click on the database name >> Properties >> Permissions >> Add the user that needs to see the tables >> Check the "View Definition" box

Let me know if this helps! Good luck 🙂

david_wendelken SSCrazy Points: 2388 More actions · Answer 3

Sadly, that isn't helping.

Already tried that. 🙁

Removed the user and recreated it. Verified it synchs up with the login.

granted datareader and public, then select and view_definition to some of the views.

Any other ideas?

david_wendelken SSCrazy Points: 2388 More actions · Answer 4

Got excited when a colleague suggested it might be a user-entered filter in SSMS.

Wasn't, but it might be helpful to the next person with this problem...

DBAgal Hall of Fame Points: 3185 More actions · Answer 5

The only way I got the views to show up in SSMS under "Views" was to grant the user "View Definition" rights at the database level, not at the individual view level, which is what you did.

Right click on the database name (not the view name) >> Properties >> Permissions >> select the user >> Click on "View Definition" checkbox. This will let the user view the structures.

david_wendelken SSCrazy Points: 2388 More actions · Answer 6

You had it right the first time, I just misread what you told me.

Thanks for taking the time to slap me upside the head and tell me to pay more attention! :w00t:

DBAgal Hall of Fame Points: 3185 More actions · Answer 7

david_wendelken (8/24/2010)
You had it right the first time, I just misread what you told me.
Thanks for taking the time to slap me upside the head and tell me to pay more attention! :w00t:

Haha no problem 🙂 Glad I could help! 🙂