Hi everyone,

does anyone here know how to hide database diagram on SQL Server 2000 ? thx a lot before

The list of Diagrams is retrieved by calling dt_getobjwithprop_u in the database where the diagram is.

So to hide all diagrams from certain users you could revoke execute permission FROM Public and grant execute only to the role that you want to be able to see the diagrams. (After every Service Pack it may be necessary to redo this).

Otherwise, you could really tempt Murphy's law by modifiying the above mentioned stored procedure to perform more complex logic to authorize or deny.



David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com

If you want you can also drop the table that they are stored in. It is a table that is not needed for SQL 2000 to function.

Small point, just FYI....

hmmm i already tried to revoke the exec permission, but it still shown up.....i want to hide the all diagram feature just like master. and would you give me an example what should i do.....thx again