Re: Unable to View Database Diagrams

Added a Windows Authenticated User with db_DataReader access to a database
and they are unable to view the database diagram. Is there some permission
I
am missing?

Hi John,

Only the database owner and members of the db_owner role can access/view a
diagram. Here's the quote from the Books Online topic Understanding
Database Diagram Ownership
http://msdn2.microsoft.com/en-us/library/ms186345.aspx. "Though any user
with access to a database can create a diagram once it has been created, the
only users who can see it are the diagram's creator and any member of the
db_owner role."

--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx

"John Barr" <JohnBarr@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:65BD716C-E029-451B-8F06-AF7C163D9E2E@xxxxxxxxxxxxxxxx
Added a Windows Authenticated User with db_DataReader access to a database
and they are unable to view the database diagram. Is there some permission
I
am missing?


.