Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2007
    Posts
    41

    Unanswered: Security in 2005

    Hi All,

    I have a problem related to Security in SQL 2005

    I have a database say "db1" which has already been
    created by some user who is having admin privilege's.

    Created a login say "manu". he doesnt have any server
    roles.

    Created a new database user "manu" in the database
    "db1" and granted him "db_owner" database role.
    Means he is owner of the database and can do anything
    with that database. Right!

    Now i logged in to the instance using "manu" login
    and am able access the database "db1" and created 3
    tables. Now when i am trying to create a Database
    diagram am getting the below error.

    "
    Database diagram support objects cannot be installed
    because this database does not have a valid owner. To
    continue, first use the Files page of the Database
    Properties dialog box or the ALTER AUTHORIZATION
    statement to set the database owner to a valid login,
    then add the database diagram support objects.

    "

    My doubt is "manu" is already owner of that database,
    then why he is not able to create a new diagram.



    Again as "sa" i have created new database,created new
    login, created new user, made owner for the newly
    created database and logged in as newly created
    login. Now am able to create new database objects and
    also am able to create Database Diagrams.

    My doubt why i am not able create the database
    diagrams in my first case.

    Please suggest me to fix this one.

    Thanks in advance.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    There are owners, and there are members of the db_owner role. when you run sp_helpdb, you will see the owner of the database. Anyone in the db_owner role enjoys many of the same rights as that owner, but are not truly the owner.

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Right-click the database in Management Studio.
    Select the "Files" page in the folder menu on the left.
    What value is specified for the Owner?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Jun 2009
    Location
    CA, USA
    Posts
    59

  5. #5
    Join Date
    Nov 2007
    Posts
    41
    Thank You All!

Posting Permissions

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