Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, July 19, 2016 6:46 AM
Points: 77, Visits: 188
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
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, July 19, 2016 6:46 AM
Points: 77, Visits: 188
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: Today @ 3:51 AM
Points: 153, Visits: 1,038
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


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, July 12, 2016 1:34 PM
Points: 806, Visits: 650
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