Thursday, November 10, 2011

Granting SQL Server Profiler Access To Users

In SQL Server 2005 and higher versions, you can give Profiler access to developers without having to make them as a member of sysadmin Role. Remember the user can trace entire server, specific database grant is not possible this is a system wide permission.

Here is the query for granting Profiler access to users. 

USE master; 
GO 
GRANT ALTER TRACE TO [Username]; 
GO
Granting SQL Server 2005 Profiler Access. Granting SQL Server 2008 Profiler Access. Granting SQL Server 2012 Profiler Access. access Rights to Profiler. How to run SQL Profiler without sysadmin rights. How to give access to SQL Profiler without giving sysadmin rights. How to Grant ALTER TRACE permission using. Permissions Required to Run SQL Server Profiler. Grant SQL Profiler. Admin access to romaing profiles. Required Permission to Run Profiler Trace on a MS SQL Server SQL Profiler & Access Rights. How do I grant or restrict a user's access to specific profiles. Set Profiling Permissions. SQL Profiler with non sysadmin role in SQL Server

0 comments:

Post a Comment