Database Diagrams

Do you need to be a member of the dbo role or an sa on a particular sql server to create a database diagram? I just want to confirm this is the case.
Any assistance will be helpful.
MariaYou have to logged as dbo or system administrator (sa or member of server group system administrators).|||Great, that's what I thought.

Thanks,

Maria|||Even if you are not a dbo or sysadmin, you can still create the diagrams and save them. But you will not be able to make changes to the tables as you don't have DML permissions.|||Okay, that is the problem. My developers can't seem to create a database diagram because the message is that they don't have sufficient permissions. Is there a particular role that they should be assigned to in order to do this? Or a level of permissions that is associated?

Maria|||Make sure the following stored procedures exist in the database:

dbo.dt_getobjwithprop_u
dbo.dt_adduserobject
dbo.dt_setpropertybyid_u
dbo.dt_getpropertiesbyid_u|||Great, I'll try that tomorrow and let you know.

Maria|||Hi,

The procs exist in the database. The problem is that my users are still unable to create the diagrams on the db. It claims they don't have enough permissions.

That's where the initial inquiry came into play. If this is wrong and they should be able to create a diagram regardless of the role they are grouped into on the db, then does anyone know what the problem is?

Maria