Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2009-06-05 : 08:11:54
|
| 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. |
|
|
|
|
|
SQL 2005 Securtity doubt