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
posted @ 2018-05-23 11:50  rosewong  阅读(160)  评论(0编辑  收藏  举报