Post reply

Database Diagram

  • June 10, 2003 at 9:06 am

    #82124

    What are the minimum sql permissions needed by a user to view\create a database diagram?

    Bill

  • June 10, 2003 at 10:06 am

    #460612

    You need create table and select permissions.

  • June 11, 2003 at 6:43 am

    #460742

    To grant 'view diagrams' permissions to a role or login , grant execute permissions on

    dt_getobjwithprop_u

    dt_getpropertiesbyid_u

    This will allow viewing of the diagrams only with no update ability.

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

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