title: SQL Server Management Studio Display Database Diagrams (ER) Permissions
body: <p>I was wondering if anybody knew exactly what permissions where needed on a database in SQL Server 2005+ so that when a person uses SQL Server Management Studio, they could then be able to at minimum see the Database Diagrams.</p>
  
  <p>I have tried giving the person db_datareader, db_datawriter, and db_ddladmin, but to no avail.  </p>
  
  <p>I have also tried giving them access in the Properties → Effective Permissions of the user.  Under Effective Permissions, I could not find the database object type for "database diagrams" or anything like that to give the user access to.</p>
  
  <p>They are running SQL Server Management Studio (non-express version.)</p>
  
  <p>Any help would be great.  </p>
  
  <p>FYI, I did not want to give them db_owner access.</p>
  
  <p>EDIT: </p>
  
  <ol>
  <li>As to one of the comments: Yes, the database is an SQL Server 2005 database.</li>
  <li>As to one of the answers, moving the DB from production to development is not an option. </li>
  </ol>