SQL Profile trace run access grant
From:https://www.mssqltips.com/sqlservertip/3559/how-to-grant-permissions-to-run-sql-server-profiler-for-a-non-system-admin-user/
Steps to give access to run SQL Server Profiler for a non sa user
1.create a login and grant as db_owner for specify database;
2.grant alter trace permission to login
-- To Grant access to a Windows Login
USE Master;
GO
GRANT ALTER TRACE TO [DomainNAME\WindowsLogin]
GO
-- To Grant access to a SQL Login
USE master;
GO
GRANT ALTER TRACE TO sqllogin
GO