Error: In order to run a trace against SQL Server you must be a member of sysadmin fixed server role or have the ALTER TRACE permission.
Description: When try to run the SQL Server Profiler using less privileged or minimal permissions credentials, this exception throws.
Solution: Provide ALTER TRACE permission for the particular user. Other ways are by providing, the user sysadmin fixed server role access which is not advised unless required.
USE master GO GRANT ALTER TRACE TO user1 GO
REVOKE the access
USE master GO REVOKE ALTER TRACE FROM user1 GO
Another way to grant rights, login with sysadmin login then open SSMS
~~ Open Security then Logins
~~ Right click on the login name and click Properties
~~ Securables tab
~~ Click Search to Select the instance that required permissions
~~ Under Explicit tab
~~ Select the check box ALTER trace permission and Click OK.