Post reply

View diagram without db_owner permission

  • February 4, 2009 at 2:18 am

    #204913

    Hi All,

    I have trouble using diagram in SQL Server 2005.

    Here is the scenario:

    I have a database with 2 different database designers. I didn’t give them db_owner role but they are the member of the following roles:

    -db_datareader

    -db_datawriter

    -db_ddladmin

    -db_securityadmin

    Now when designer 1 creates a diagram the other designer (designer 2) can’t view it. I try to give some permission on DBO Schema such as Select or View Definition but no use.

    Please provide me help to manage this problem.

    Thanks in advance,

    Sani.

  • February 4, 2009 at 2:47 am

    #937773

    Hello,

    You may be stuck with this one as according to BOL 2005: “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.”

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

  • February 4, 2009 at 3:02 am

    #937779

    Dear John Marsh,

    Thank you for your reply.

    I have checked the comment in BOL 2005 but I think It might be a way to handle these kind of permission as SQL Server 2005 implement more granularity in term of security.

    Any other comment regarding this issue will be greatly appreciated.

    Thanks,

    Sani.

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

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