What Permissions are Needed to Create Database Diagrams?

Hi there this is MSSQL 2014
Do you have to have the db_owner role to create a database diagram or can I simply grant certain permissions to the developer who wants to create diagrams? Thanks, John

Hi,
it seems got a very detail answer here:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/de6cb842-ecac-4c6e-b5b7-85ae62edbc0e/cant-create-database-diagrams?forum=sqlsecurity

Thanks DennisC. I read that post. I think it would be a big hassle to do this without then having the db_owner role. Maybe someone else can suggest a better option. Thanks again, John

To create a databae diagram must set up by a member of the db_owner role. You need to be a Database Owner for Database Diagrams. Please move on this know the detailed how can we design the Database Diagrams. https://msdn.microsoft.com/en-us/library/ms186345(SQL.90).aspx

1 Like

Thank you, Jason_clark.