In SQL Server 2005 / 2008 to grant SQL Profiler access for a user;
Security tab --> Logins --> right click name to modify select properties --> securables tab --> Click add --> Select the server you want to add the permissions to. The permissions should appear in the effective permissions list
USE master;
GRANT ALTER TRACE TO [Username];
-->Where User Name for domain account is [Domain\accountname];
No comments:
Post a Comment