1

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?
Sandeep Chatterjee
  • 3,220
  • 9
  • 31
  • 47
Geetanjali Sachdeva
  • 133
  • 1
  • 5
  • 14

1 Answers1

0

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.

Kritner
  • 13,557
  • 10
  • 46
  • 72
  • Thanks Kritner! Is there any other way to copy the diagram somewhere else and send it the other person? – Geetanjali Sachdeva Feb 18 '15 at 18:30
  • Well you can right click the canvas of the diagram and "Copy to Clipboard" though it won't have the interactiveness that the diagram itself has (it'll just be an image) - but that's one way to do it. – Kritner Feb 18 '15 at 18:32