November 13, 2003 at 4:14 pm
Apologies for what I think is a question that's going to have a very obvious answer, but I've not yet found it! This is my first foray into diagrams, as perhaps you will tell.
I have a database with diagrams that I need to give the necessary permissions to a login so that the user of said login can view (perhaps edit) the diagram. What permissions are required (or what roledoes the user need to be a member of)?
Thanks in advance for any ideas.
Steven
November 17, 2003 at 8:00 am
This was removed by the editor as SPAM
November 17, 2003 at 6:44 pm
I've never thought about this. However the diagram is stored in the dtproperties table so I would assume the user would at the very least need to have the ability to add/update/delete records in that table.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
November 18, 2003 at 2:28 am
This one might help you http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=13025 in addition to what Gary already has said
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply