I'm hoping someone already has a script out there to grant only necessary
permissions (not SA role membership) for a user to run the following:

Database Tuning Advisor
SQL Profiler
Activity Monitor (for all sessions)

Any help would be appreciated.

Thanks in advance.