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 privileges to server and database properties in SQL2008R2 SSMS? Expand / Collapse
Author
Message
Posted Tuesday, October 22, 2013 3:14 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, July 25, 2014 1:59 AM
Points: 20, Visits: 136
Hello,

I have a requirement to enable my Technical Architect limited permission to SSMS.
He requires to only view the server properties, and database properties of all databases on the server.
I have tried a number of methods to grant permissions, though havent managed to find a solution.

Can someone please help? Thanks
Post #1507025
Posted Tuesday, October 22, 2013 11:32 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 2:59 PM
Points: 153, Visits: 973
dp75 (10/22/2013)

He requires to only view the server properties, and database properties of all databases on the server.


The real problem are the database properties.
If you are refering to the properties which are available via SSMS, as I assume, then those require some access to the respective database itself. - Which in your case seem to be all of them.
So while the first part works for the most part with "VIEW SERVER STATE", for the second part you need to create a user in all those databases, and give or deny the respective permissions - dependig on how you actually start.

If anyone happens to have a better idea, I'd be happy to know. Right now I can't think of any better.



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 #1507261
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse