User unable to view Diagrams in SSMS

  • A user has read access to a user db and is unable to view existing diagrams. I changed it so he has db_owner access, but still unable to view diagrams. This is a development box. Any suggestions?

    ¤ §unshine ¤

  • Only the owner of the diagram i.e. the user who created it or a member of the db_owner or sysadmin roles can open a diagram.

    We have developers use a third party CASE tools to create diagrams because those can be shared.

    Greg

  • Thank you. I'm going to try creating a schema for the group to see if that works somehow. We have a 3rd arty tool but not for all members. Let's see what we can work with.

    Thanks again!

    ¤ §unshine ¤

  • Okay, good luck. I haven't had any luck getting around the security.

    Greg

Viewing 4 posts - 1 through 3 (of 3 total)

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