We have a third-party package ("GetPaid") which uses schema's other than dbo.
I've granted select on all tables to a user, and they can truely select from said tables, however they don't see them in object explorer in SSMS.
I've granted View definition on the schema to the users but the objects still don't show up.
The only way I can get this to work (so far) is to change the schema owner of that schema to dbo.
What impact exists if I change the schema owner?
for example:
Schema................test1
Schema owner.......test1
Table: ------------test1.mytable
User:...................test
Login with user test and cannot see table test.mytable in object explorer
Schema................test1
Schema owner.......dbo
Table: ------------test1.mytable
User:...................test
Login with user test and CAN see table test.mytable in object explorer
thanks in advance for any and all help 🙂
Ben Pflanzer
Stericycle, Inc.