Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Read-only access to data AND database design? Can it be done? Expand / Collapse
Author
Message
Posted Wednesday, September 25, 2013 4:28 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 6:39 AM
Points: 68, Visits: 153
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?
Post #1498237
Posted Wednesday, September 25, 2013 5:04 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 6:39 AM
Points: 68, Visits: 153
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.


Post #1498257
Posted Wednesday, September 25, 2013 8:16 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, September 8, 2014 1:07 PM
Points: 153, Visits: 979
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
Post #1498388
Posted Monday, October 21, 2013 3:19 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: 2 days ago @ 1:14 AM
Points: 735, Visits: 553
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.
Post #1506888
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse