Post reply

Permission to view database diagrams

  • August 21, 2006 at 11:58 am

    #94180

    Our developers have only db_datareader rights on our production database. They asked me to give them privileges to view database diagrams as well. Is there a set command for this ? And BTW, where I can find all list of security sets ? Are they in some sys. table or view ?

    Thanks

     

  • August 21, 2006 at 2:38 pm

    #655987

    Mark,

    I am able to create database diagrams connected as db_datareader user. Books Online say in the article

    "Understanding Database Diagram Ownership (Visual Database Tools) "

    http://msdn2.microsoft.com/en-us/library/ms186345.aspx

    • Although 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.
    • 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.

    As for the references, you can use Books Online that are installed with SQL Server and accessible through the startup menu or you can see them online at the Microsoft website.

     

     

    Regards,Yelena Varsha

  • August 21, 2006 at 3:27 pm

    #656007

    Hi Yelena,

    I can also create diagrams under a login with just db_datareader role membership, but what I want is to be able to view the diagrams that have been created under a login having dbo or sa privileges.

    Thanks,

    Mark

     

  • August 21, 2006 at 4:05 pm

    #656015

    I don't think that this article says that we can do it. I would use third-party tools like ERwin or ERstudio to do that. Another alternative is to create diagrams in Visio Enterprise Architect:

    http://www.microsoft.com/office/visio/prodinfo/editions.mspx

     

     

    Regards,Yelena Varsha

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply