Read-only access to data AND database design? Can it be done?
-
I want to give a fellow developer read-only access to a set of databases that collectively form an application. He wants to borrow some design ideas, and I am happy for him do this.
When I set him up with db_datareader access. he could only see the data. How do I also give him read-only access to the design of views, tables, functions and stored procedures?
-
The answer seems to be as follows:
1) In Login Properties, click on Securables
2) Choose the relevant Server as a Securable
3) grant my colleague the Permission to "view any definition"
This seems to let him see the design of tables, views and Stored Procedures.
-
That's the way
Andreas
---------------------------------------------------
MVP SQL Server
Microsoft Certified Master SQL Server 2008
Microsoft Certified Solutions Master Data Platform, SQL Server 2012
www.insidesql.org/blogs/andreaswolter
www.andreas-wolter.com -
MarkThornton (9/25/2013)
The answer seems to be as follows:1) In Login Properties, click on Securables
2) Choose the relevant Server as a Securable
3) grant my colleague the Permission to "view any definition"
This seems to let him see the design of tables, views and Stored Procedures.
Not sure if this helps but you can also set this at the database level if you want to make this access more granular.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply