If you look up "Setting up script triggers" in FileMaker help, you'll find that this trigger is tripped first, then FileMaker processes the event that tripped the script trigger. So your script takes the user to the object "Create Jobs", then processes the tab panel change and puts the user on the clicked tab panel.
To keep the triggering event from being processed by FileMaker when it's a "before the event" trigger of this type, add this step after the Go To Object script step:
Exit Script [False]
The False parameter tells FileMaker to not process the triggering event and then a click on tab 6 won't still leave the user on tab 6 when the privilege set is named "photographer".
Thanks Phil...that worked perfectly. I had tried to put in the Exit Script but did not know about the False result. That was the missing link.