August 18, 2009 at 3:51 pm
My QA guy is datareader/writer, but I also want him to be able to see the DB diagrams. How can I do that without making him db_owner?
TIA,
[font="Courier New"]ZenDada[/font]
August 19, 2009 at 8:55 am
according to BOL is looks like you are out of luck
To use Database Diagram Designer it must first be set up by a member of the db_owner role (a role of SQL Server databases) to control access to diagrams. Each diagram has one and only one owner, the user who created it. For more information on setting up diagramming see How to: Set Up Database Diagram Designer (Visual Database Tools).
Some points to keep in mind about diagram ownership:
Although any user with access to a database can create a diagram, once the diagram has been created, the only users who can see it are the diagram's creator and any member of the db_owner role.
Ownership of diagrams can only be transferred to members of the db_owner role. This is only possible if the previous owner of the diagram has been removed from the database.
If the owner of a diagram has been removed from the database, the diagram will remain in the database until a member of the db_owner role attempts to open it. At that point the db_owner member can choose to take over ownership of the diagram.
You can print them out for him.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 19, 2009 at 9:07 am
Thx - I'll kill some trees.
[font="Courier New"]ZenDada[/font]
August 25, 2009 at 9:38 pm
Should look into the Cute PDF writer which you can effectively "Print" to a PDF and then you could send over the PDF's.
http://www.cutepdf.com/Products/CutePDF/writer.asp
Regards,
Steve
September 6, 2009 at 12:08 pm
rather then diagrams i suggest to use software like:
sql doc: http://www.red-gate.com/products/SQL_Doc/index.htm
or
apexsql doc: http://www.apexsql.com/sql_tools_doc.asp
i was using both, both are very good - but redgate tool is much faster
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply