October 22, 2013 at 3:14 am
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
October 22, 2013 at 11:32 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply