Re: Unable to View Database Diagrams
- From: Don Kiely <donkiely@xxxxxxxxxxxx>
- Date: Sat, 08 Dec 2007 08:04:40 -0900
>> Though any user with access to a database can create a diagram once it has been created
Um, they can only create it once it has been created? Sounds like a bit of a problem.
What is this supposed to say? Does it mean once the *database* has been created? But that doesn't do much for me. I don't normally want a diagram of a non-existent database. So the sentence must mean something else.
Don
Gail Erickson [MS] wrote:
.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."
- Follow-Ups:
- Re: Unable to View Database Diagrams
- From: Gail Erickson [MS]
- Re: Unable to View Database Diagrams
- References:
- Re: Unable to View Database Diagrams
- From: Gail Erickson [MS]
- Re: Unable to View Database Diagrams
- Prev by Date: Re: current security context is not trusted (cross db ownership ch
- Next by Date: sell running sport shoes(accept paypal)(www.24hoursneakers.com)
- Previous by thread: Re: Unable to View Database Diagrams
- Next by thread: Re: Unable to View Database Diagrams
- Index(es):
Relevant Pages
|
