Via Tara: This forum post shows a method of setting up access to Profiler without granting sysadmin access.
It's not perfect -- a network trace or possibly hex-editing the executable will give up the password. But it's at least somewhat better than giving sysadmin access to every member of a development team, just so Profiler can be run (as I've had to do on multiple occasions).