![sql server 2012 profiler permissions sql server 2012 profiler permissions](http://www.mergetool.com/addin_e/screenshots/faq0015/SNAG-0005.png)
Step 3: First let's grant the rights in SSMS. GRANT/REVOKE ALTER TRACE permission in SQL Server Management Studio
![sql server 2012 profiler permissions sql server 2012 profiler permissions](https://dhmacher.files.wordpress.com/2017/09/ssms-effective-permissions.png)
We can grant this access in either SSMS or by running T-SQL commands. Now as I said before, we must not give sysadmin rights to any users on database servers except DBAs, so we will give this user GRANT permission on ALTER TRACE to run SQL Server You can see in the above screenshot that user manvendra is created with the db_owner permission on a user database.
![sql server 2012 profiler permissions sql server 2012 profiler permissions](https://docs.microsoft.com/en-us/sql/tools/sql-server-profiler/media/replaytracedecisiontree.gif)
Step 1: First we should create a login id and a user and assign that user db_owner access on a database to create similar scenario. Steps to give access to run SQL Server Profiler for a non sa user Also it is highly recommended that you not give this kind of permission to a user in production environments. Since this user is not a DBA we should not grant the sysadmin server role to anybody except DBAs on database servers. This user was neither part of the sysadmin server role nor has GRANT permission on ALTER TRACE. Profiler or those users who have the GRANT permission on ALTER TRACE can run SQL Server The error shown in the screenshot suggests that only a member of the sysadmin fixed server role can run SQL Server Therefore, we recommend that you only grant these permissions to users who are authorized to view sensitive information." These queries may contain sensitive information such as passwords. NOTE: As per the Microsoft MSDN site "Users who have ALTER TRACE permission can view queries that are captured in This is a server-level permission, and allows access to start, stop, or modify a trace, in addition to being able to generate user-defined events. To be a bit too inflexible for many development teams, and as a result, a new permission introduced in SQL Server 2005, called ALTER TRACE Stop or modify) traces before the release of SQL Server 2005. Only members of sysadmin server role were able to run (start, You can capture and save data about each event to a file or table to analyze later. Is a graphical user interface to SQL Trace for monitoring an instance of the Database Engine or Analysis Services. The user was getting this error because he was not authorized to run Received the error shown in the problem section. A user has contacted us for appropriate access to runĪ development environment so that he doesn't have to come to DBAs every time.