Post reply

Permissions for database diagram

  • September 16, 2007 at 8:21 pm

    #125666

    i have given a user db_datareader, db_datawriter  permission so that he can view table data and add and delete rows in the table only.

    but they want to see the database diagram. what permission should i give them to see the database diagram but they should not edit or delete anything. please help

    thanks

      

     

  • September 17, 2007 at 3:39 am

    #734025

    I would use a DDL trigger for the database. You can specify which changes should be prevented. Any modification to the diagram would fire the trigger and you could raise an error and rollback the change there for this user.

    ...and your only reply is slàinte mhath

  • September 17, 2007 at 9:33 am

    #734096

    Check out this:

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

    VIEW DEFINITION Permission
     
    and this:
     
    http://msdn2.microsoft.com/en-us/library/ms187113.aspx
     

    Metadata Visibility Configuration

    Regards,Yelena Varsha

  • September 17, 2007 at 2:34 pm

    #734160

    I've found that only the owner of a diagram i.e. the user who created it, or a member of the db_owner role can open diagrams.

    Greg

    Greg

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

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