How do I allow users to see objects in object explorer? (SQL2005)

  • 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.

  • bump...

    are there no smart people out there who know the answer 😛

Viewing 2 posts - 1 through 1 (of 1 total)

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