locked
Permission question RRS feed

  • Question

  • What are the minimum permissions needed to view a database diagram, and what permissions are needed to create a database diagram in sql server management studio?
    Sunday, July 19, 2020 7:06 PM

Answers

  • Below is the relevant excerpt from the documentation. Also note that non-privileged users will have limited meta-data visibility and schema change ability.

    <Excerpt>

    Although any user with access to a database can create a diagram, once the diagram has been created, the only users who can see it are the diagram's creator and any member of the db_owner role.

    Ownership of diagrams can only be transferred to members of the db_owner role. This is only possible if the previous owner of the diagram has been removed from the database.

    If the owner of a diagram has been removed from the database, the diagram will remain in the database until a member of the db_owner role attempts to open it. At that point the db_owner member can choose to take over ownership of the diagram.

    </Excerpt>


    Dan Guzman, Data Platform MVP, http://www.dbdelta.com


    Sunday, July 19, 2020 7:47 PM
    Answerer

All replies

  • Below is the relevant excerpt from the documentation. Also note that non-privileged users will have limited meta-data visibility and schema change ability.

    <Excerpt>

    Although any user with access to a database can create a diagram, once the diagram has been created, the only users who can see it are the diagram's creator and any member of the db_owner role.

    Ownership of diagrams can only be transferred to members of the db_owner role. This is only possible if the previous owner of the diagram has been removed from the database.

    If the owner of a diagram has been removed from the database, the diagram will remain in the database until a member of the db_owner role attempts to open it. At that point the db_owner member can choose to take over ownership of the diagram.

    </Excerpt>


    Dan Guzman, Data Platform MVP, http://www.dbdelta.com


    Sunday, July 19, 2020 7:47 PM
    Answerer
  • Thanks Dan
    Monday, July 20, 2020 12:36 AM