Re: Unable to View Database Diagrams



>> 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."

.



Relevant Pages

  • Re: What is analysis?
    ... database with 20 or 30 columns. ... Prototyping has always been an ... Do you se a diagram? ... Managers also couldn't get "the big picture" from a datasheet view. ...
    (comp.databases.theory)
  • Re: What is analysis?
    ... database with 20 or 30 columns. ... Prototyping has always been an ... Do you se a diagram? ... Managers also couldn't get "the big picture" from a datasheet view. ...
    (comp.databases.theory)
  • Quiz for those who are multiskilled!
    ... I'm currently interviewing for a vb.net ... **These next two question assumes that you can see a database diagram ... GetAdditionalProducerInfoStatus returns the DataRowState of a specific ...
    (microsoft.public.dotnet.languages.vb)
  • Re: View SQL diagrams if user has view definition rights via domain gr
    ... and assign it a database role with "View Definition" to a user database ... Create a default database diagram of the TestDB; ... Expand the database TestDB, expand the Database diagrams, and create a ...
    (microsoft.public.sqlserver.security)
  • Re: View SQL diagrams if user has view definition rights via domain gr
    ... These are the same steps already posted on the feedback site ... and assign it a database role with "View Definition" to a user database ... Create a default database diagram of the TestDB; ... Expand the database TestDB, expand the Database diagrams, and create a ...
    (microsoft.public.sqlserver.security)