Been there, done that 




With SQL2005 it's better (just grant alter trace)
but with sql2000, if you want it you'll need to give sysadm rights.
Avoid it for your production servers !
Implement a scenario, so they contact you to activate profiler, or start a trace to file.