Re: Unable to View Database Diagrams

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

The sentence I quoted is out of context. If you read it within the paragraph
of the topic I linked to, you'll see that "it" does refer to the database.

--
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
"Don Kiely" <donkiely@xxxxxxxxxxxx> wrote in message
news:%23mQutxbOIHA.5208@xxxxxxxxxxxxxxxxxxxxxxx
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)