SQL Server: permissions to read database diagrams

sql-server sql-server-2005 permissions database-permissions
Budda picture Budda · Jan 11, 2011 · Viewed 14.3k times · Source

Could you please advise, what are permissions required to give user access to read Database diagrams in SQL Server 2005?

Thanks a lot!

Answer

gbn picture gbn · Jan 11, 2011

From BOL

  • Although any user with access to a database can create a diagram, once the diagram has been created, the only users who can see it are the diagram's creator and any member of the db_owner role.
  • Ownership of diagrams can only be transferred to members of the db_owner role. This is only possible if the previous owner of the diagram has been removed from the database.
  • If the owner of a diagram has been removed from the database, the diagram will remain in the database until a member of the db_owner role attempts to open it. At that point the db_owner member can choose to take over ownership of the diagram.

So, db_owner/dbo is best

Related questions

How do I change the owner of a SQL Server database?

When I accidentally click on the Database Diagrams tab, I get one of the following errors: Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of …

Read More
Built-in database role in SQL Server 2005 to permit execution of stored procedures?

In SQL Server 2005, there are built in roles: db_datareader db_datawriter etc. Is there any role that lets a user execute an stored proc? I don't want to use db_owner, because that will permit deletion and updates, which …

Read More
Add a column with a default value to an existing table in SQL Server

How can I add a column with a default value to an existing table in SQL Server 2000 / SQL Server 2005?

Read More