Right to create db diagrams

Hello,
Does anyone knows which right has to be assigned to a user so that it can cr
eate a database diagram.
Indeed, we currently have users having the rights of connection and the role
s following: db_datareader, db_datawriter and db_ddladmin.
With these roles, the creation of a new diagram of dB raises an error indica
ting that the user does not have the authorizations necessary to create a ne
w diagram.
Which role, or grant XX, can solve this concern?
thanks
AlexandreWhat version of SQL Server and what is the exact error
message?
If you are on SQL Server 2000, the users in those roles
should be able to create the diagrams under most
circumstances. The warning that initially pops up would be
something like "you aren't logged on as database owner or
system administrator. You might not be able to save changes
to tables that you don't own" but that won't prevent them
from actually creating the diagram
If the error you get is "You do not have sufficient
privileges to create the new diagram", then you may be
running into the following issue:
FIX: You Cannot Create Diagrams in SQL Enterprise Manager If
You Are Not a Database Owner
http://support.microsoft.com/?kbid=327145
-Sue
On Tue, 16 Mar 2004 01:16:08 -0800, "Alex"
<anonymous@.discussions.microsoft.com> wrote:

>Hello,
>Does anyone knows which right has to be assigned to a user so that it can c
reate a database diagram.
>Indeed, we currently have users having the rights of connection and the rol
es following: db_datareader, db_datawriter and db_ddladmin.
>With these roles, the creation of a new diagram of dB raises an error indic
ating that the user does not have the authorizations necessary to create a n
ew diagram.
>Which role, or grant XX, can solve this concern?
>thanks
>Alexandre|||Hi,
Thanks for the input.
I was running into the issue you have mentionned, and the workaround in the
note works fine to correct this.
Alex