I created a database diagram and but other user is not able to view the database diagram. What access permissions does the other user need?

Question

I created a database diagram in SQL database but the other person in my team is unable to view it, it might be because of different access permissions to that server.

• What permissions does the other user need to be able to view the database diagram?
• Is there any other way I can send the database diagram to that user( like copy the database diagram somewhere and share it?)
• Which other softwares help in creating database diagram?

Answer 1

Reference database diagram documentation:

https://msdn.microsoft.com/en-us/library/ms186345(v=sql.110).aspx

It states basically:

User who created it and db_owners can view them.