sqlsql-server-2008-r2database-diagram

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?


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.


Solution

  • 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.