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 |
|
laailalalaa
Yak Posting Veteran
57 Posts |
 Posted - 2009-03-02 : 07:02:57
|
| hii created a database as an sa. then i created a login and a corresponding user for the created database. after i login as that simple user and create some tables i try to create a diagram. when clicking on the Database Diagrams node in Object Explorer, the following message pops up: "A member of the db_owner role must use the database diagramming functionality in order to setup the required database diagramming objects on the SQL Server". So how do i let a simple user create and use diagrams?Thanks |
|
|
laailalalaa
Yak Posting Veteran
57 Posts |
Posted - 2009-03-02 : 07:06:54
|
| problem solved:Dif anyone else has the same probl.. i logged in as an sa (i think it would suffice to log in as the db owner), created the required support objects for db diagramming, then logged in as the simple user.. and i was able to create a diagram |
 |
|
|
subhash chandra
Starting Member
40 Posts |
Posted - 2009-03-02 : 07:54:23
|
| Yes, Database Diagram can only be created in databases that have a owner specified. |
|
|
|
|
|
|
use diagramming when not db owner