| toby@ovod-everett.org 2006-02-13, 1:23 pm |
| I have a user who has db_ddladmin, db_datareader, and db_datawriter on
a database hosted on a server running SQL Server 2000 SP4. The SQL
Server tools are installed on his machine and SQL Server 2000 SP4 was
run against his machine after the install. He reported the "You do not
have sufficient privileges to create the new diagram." error message.
I did some quick web research and found
http://support.microsoft.com/?id=327145. That article indicates that
the problems should have been fixed in SP1. The database was created
on the server after SP4 was installed on the server and was using a
client machine that has the SQL Server tools installed and SP4 applied.
The above KB article mentions verifying permissions for public on a
whole host of stored procedures and on the dtproperties table. I
verified that all of these permissions were present. I did, however,
notice that public lacked SELECT permissions on sysfiles1,
sysfulltextnotify, and sysproperties. When I granted SELECT
permissions on sysproperties to public, the problem disappeared.
I was not able to find any mention of sysproperties anywhere in the
Microsoft KB. Should I grant SELECT permissions to public on sysfiles1
and sysfulltextnotify as well? It already has SELECT permission on all
of the other sys* tables.
--Toby Ovod-Everett
|