• You could give the user the ALTER TRACE permission and let them run the Profiler when they need it.

    Just be sure to tell them how NOT to use it first though!