Disable database diagram creation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

slousch@gmail.com - 24 Oct 2006 16:38 GMT

I have a MSSQL 2000 SP4 server.
I need to disable ability to create database diagrams for users.
How can I do this?

Reply to this Message

Sue Hoegemeier - 25 Oct 2006 02:57 GMT

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

>I have a MSSQL 2000 SP4 server.
>I need to disable ability to create database diagrams for users.
>How can I do this?

Reply to this Message

slousch@gmail.com - 25 Oct 2006 12:09 GMT

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.

> To create a diagram, they would need to be the database
> owner or a member of the db_owner role (or a sysadmin).
[quoted text clipped - 5 lines]
>
> -Sue

Reply to this Message

Sue Hoegemeier - 27 Oct 2006 00:52 GMT

Check the permissions on the objects listed in the article.

-Sue

>User is not db_owner and not in sysadmin,
>there are no permissions to public database role,
[quoted text clipped - 13 lines]
>>
>> -Sue

Reply to this Message