Try it from a different user account on your Mac Pro.
1) If it works, it's a preference problem in your old user account.
2) If it doesn't work, continue below:
Try booting from a different partition or HD. You're checking the OS install. If need be, do a fresh install on a USB flashdrive or external HD, and boot from that.
1) If it works, it's a problem with your regular OS install. Tricky to diagnose & fix, you may end up doing an archive & reinstall.
2) If it doesn't work, it's either a hardware problem with the camera, or with your Mac Pro. Continue below:
Do other FW devices still work with your Mac Pro? Shorted FW cables have been known to blow any port they are plugged into. This is unlikely because the camera light still comes on, but if this were the case, plugging it into someone else's Mac would blow their FW too.
1) Other FW devices work on your Mac, but the camera still doesn't. Try it in another Mac, but odds are it is the camera.
2) No FW devices work on your Mac, even when booted from a fresh install. Shut down, push the CUDA button SMU Reset button on the motherboard. Boot up and retest. Still no FW devices working? FW is gone on your Mac - the camera might be OK. Could be tested on another Mac, with some risk to the other Mac. Or take the camera to a Genius bar, mentioning the cable might be shorted.
3) Other FW devices don't work, but the camera does work now. I'll let someone else handle further diagnostics if this happens.
4) Camera works again - excellent. You're done, go immediately to GO and collect $200.
Edit: Stupid question, but did you try a reboot first?