SQLTeam.com | Weblogs | Forums

What Permissions are Needed to Create Database Diagrams?


#1

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


#2

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


#3

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


#4

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


#5

Thank you, Jason_clark.