The Profiler is a powerful tool available to the dba, but it can also be very useful for system developers. Of course I'm thinking about development environments (production never). Thus, the profiler can help developers monitor the queries and stored procedures developed in the applications.

Follow the instruction to grant permission for the execution of profile:

//You must be in the master database

USE master

GO

GRANT ALTER TRACE TO [username];