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,