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
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.
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.