question

DBA Cabuloso avatar image
DBA Cabuloso asked

Permissions on SQL Server 2005 database diagrams

Dear colleagues,

I have a database with several diagrams that has been restores in my SQL Server 2005. The database is compatibility level 90 and the owner is sa. (I have already entered the command: ALTER AUTHORIZATION ON DATABASE::myDatabase TO SA). My SQL Server version is 9.00.4053. The dbo can open any diagram correctly.

There is one user with the permissions db_datareader and db_datawriter. He connects correctly.

The problem is when the user tries to reach the database diagrams, using the SQL Server Management Studio. The diagrams doesn't appear. Do I have to give him the db_owner role so that he can see the diagrams created by other DBA? I don't want to do it because this user is not a Db_Owner, but he just wants to see the diagrams.

Is there any solution other than give him the db_owner role?

Thanks in advance,

DBA Cabuloso

permissions
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered

From BOL

Only the owner of the diagram or a member of the db_owner role of the database can open the diagram.

3 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image Fatherjack ♦♦ commented ·
+1 - well I never knew that. Every day is a learning day !!
0 Likes 0 ·
Kev Riley avatar image Kev Riley ♦♦ commented ·
I know - every day I learn I know less and less about SQL Server!
0 Likes 0 ·
David Wimbush avatar image David Wimbush commented ·
Me too. I used to know everything but I've learned a lot since then.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.