September 12, 2008 at 4:32 am
I am the main administrator of a SQL Server with about 20 databases.
An administrator who is responsible for 2 databases asked me today for the permission to use the activity monitor.
I want to give him the permission, but the view server state permission shows all processes on all databases.
Is ist possible to restrict this permission only to his 2 databases?
September 12, 2008 at 7:38 am
Server level permissions are Server Level. So there is no way to limit it if you grant that permission.
You could develop a report that connects with proper permissions, but, based on the user name only displays activity in the desired database. You could do a table to hold the databases and user names or just do it in code.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 15, 2008 at 5:34 am
This is the solution:
http://msdn.microsoft.com/en-us/library/ms345102(SQL.90).aspx
October 21, 2010 at 8:25 am
Roland R. (9/15/2008)
This is the solution:http://msdn.microsoft.com/en-us/library/ms345102(SQL.90).aspx
I wonder why in that link they are using SQL CLR to implement module signing. It's not necessary.
The same solution can be implemented with straight T-SQL, using the EXECUTE AS clause.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply