Results 1 to 8 of 8
  1. #1
    Join Date
    Jul 2003
    Posts
    24

    Unanswered: Database Diagrams

    Do you need to be a member of the dbo role or an sa on a particular sql server to create a database diagram? I just want to confirm this is the case.

    Any assistance will be helpful.

    Maria

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    You have to logged as dbo or system administrator (sa or member of server group system administrators).

  3. #3
    Join Date
    Jul 2003
    Posts
    24
    Great, that's what I thought.

    Thanks,

    Maria

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    149
    Even if you are not a dbo or sysadmin, you can still create the diagrams and save them. But you will not be able to make changes to the tables as you don't have DML permissions.

  5. #5
    Join Date
    Jul 2003
    Posts
    24
    Okay, that is the problem. My developers can't seem to create a database diagram because the message is that they don't have sufficient permissions. Is there a particular role that they should be assigned to in order to do this? Or a level of permissions that is associated?

    Maria

  6. #6
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Make sure the following stored procedures exist in the database:

    dbo.dt_getobjwithprop_u
    dbo.dt_adduserobject
    dbo.dt_setpropertybyid_u
    dbo.dt_getpropertiesbyid_u

  7. #7
    Join Date
    Jul 2003
    Posts
    24
    Great, I'll try that tomorrow and let you know.

    Maria

  8. #8
    Join Date
    Jul 2003
    Posts
    24
    Hi,

    The procs exist in the database. The problem is that my users are still unable to create the diagrams on the db. It claims they don't have enough permissions.

    That's where the initial inquiry came into play. If this is wrong and they should be able to create a diagram regardless of the role they are grouped into on the db, then does anyone know what the problem is?

    Maria

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •