How to let user to view diagrams

Question

How to let user to view diagrams

Atif

Hall of Fame

Points: 3578
More actions
June 3, 2009 at 12:30 am

#132922

I have created a new login on SQL Server 2000. In a database user have been assigned two roles that are db_datareader and db_datawriter. In SSMS user can not view any defined diagrams. The folder for diagrams is empty. How can i let the user to view diagrams and work with them?
Regards
DBDigger Microsoft Data Platform Consultancy.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

John H Marsh SSChampion Points: 11671 More actions · Answer 1

Hello,

To quote Books Online (admittedly 2005): „Although any user with access to a database can create a diagram once it has been created, the only users who can see it are the diagram's creator and any member of the db_owner role“.

Which means you would have to grant the db_owner Role to your users, and may be you don’t want to do that?

Regards,

John Marsh

www.sql.lu
SQL Server Luxembourg User Group

Atif Hall of Fame Points: 3578 More actions · Answer 2

Thanks Marsh,

Certainly it would be a costly to assign db_owner Role to a user for just to let him view the database diagrams. Any other suggestion is welcomed.

DBDigger Microsoft Data Platform Consultancy.

Atif Hall of Fame Points: 3578 More actions · Answer 3

Thanks Marsh,

Certainly it would be a costly to assign db_owner Role to a user for just to let him view the database diagrams. Any other suggestion is welcomed.

DBDigger Microsoft Data Platform Consultancy.

Scott Coleman One Orange Chip Points: 27452 More actions · Answer 4

If your diagrams are on a SQL 2000 server, I seem to recall that the trick was not adding database roles for the user but to grant public execute rights on some "dt_" stored procs. I don't recall which procedures, but a web search may turn it up.

I also don't know if that affects diagram display in SSMS, or only in Enterprise Manager.