Provide a SQL Login ALTER TRACE permission
One SQL login holder asked DBA team “Please provide me profiler access urgently“. Mentioned user using a SQL login and he wants to run profiler on a particular database of a production server. A screenshot also shared by that user.
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.
As the user already has ‘SQL login’ and ‘DATABASE user’ we checked and assigned that user ‘db_owner’. Then provide ‘ALTER TRACE‘ permission to the use.
-- For Windows Login USE Master go GRANT ALTER TRACE TO [DOMAIN_NAME\WINDOWS_LOGIN] go -- For SQL Login USE master go GRANT ALTER TRACE TO [SQL_LOGIN] go