none
access diagrams

Answers

  • As far as I know DB diagrams created using SSMS can only be viewed by either the creator themselves or members of the db_owner role. So you cant provide just read access to diagrams for any one user/group

    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    Sunday, July 8, 2018 3:34 PM

All replies

  • As far as I know DB diagrams created using SSMS can only be viewed by either the creator themselves or members of the db_owner role. So you cant provide just read access to diagrams for any one user/group

    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    Sunday, July 8, 2018 3:34 PM
  • Thanks!
    Sunday, July 8, 2018 3:38 PM
  • Thanks!

    Welcome

    You may mark relevant posts as answer to close the thread if you've got the answer to your question


    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    Sunday, July 8, 2018 4:13 PM
  • Yes and no. That is, I don't think it is supported, but since access to the diagrams is through a couple of stored procedures stored in the database, you could try to modify these to your needs. You find these procedure, by expanding the node Stored Procedures and then System Stored Procedures. You find the procedures on top of the list, and easily discernable from the rest, since they are in the dbo schema.

    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

    Sunday, July 8, 2018 8:40 PM