Disable database diagram creation

I have a MSSQL 2000 SP4 server.
I need to disable ability to create database diagrams for users.
How can I do this?To create a diagram, they would need to be the database
owner or a member of the db_owner role (or a sysadmin).
Don't add them to those roles.
You can figure out the specific object permissions in the
following article - different issue than yours but it lists
the permissions.
http://support.microsoft.com/?id=327145
-Sue
On 24 Oct 2006 08:38:06 -0700, slousch@.gmail.com wrote:

>I have a MSSQL 2000 SP4 server.
>I need to disable ability to create database diagrams for users.
>How can I do this?|||User is not db_owner and not in sysadmin,
there are no permissions to public database role,
but he is still able to create diagrams.
I want to get "You do not have sufficient privileges to create the new
diagram." message,
when user trying to creaate diagram.
Sue Hoegemeier wrote:
> To create a diagram, they would need to be the database
> owner or a member of the db_owner role (or a sysadmin).
> Don't add them to those roles.
> You can figure out the specific object permissions in the
> following article - different issue than yours but it lists
> the permissions.
> http://support.microsoft.com/?id=327145
> -Sue|||Check the permissions on the objects listed in the article.
-Sue
On 25 Oct 2006 04:09:54 -0700, slousch@.gmail.com wrote:
[vbcol=seagreen]
>User is not db_owner and not in sysadmin,
>there are no permissions to public database role,
>but he is still able to create diagrams.
>I want to get "You do not have sufficient privileges to create the new
>diagram." message,
>when user trying to creaate diagram.
>Sue Hoegemeier wrote: