ER Daigram | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

ER Daigram

Hi can any tell me, how can i restrict access only to the Database design daigram for the developers, so that they cant change any thing over there. Thanks!
"He laughs best who laughs last"
KBA for information. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Are you talking about your production server or a test server? Personally developers at my location do not have access to the database server at all, except via the application like everyone else. On the test server they can have whatever access they want. If you mean minimum access required to view an existing diagram, then even an id that is only a member of the datareader role can view a diagram (but not make changes) If they need to make changes they need to be db_owner.