why don't you use one of the cohort plugins to do this instead?
this one lets you look at the "auth" field:
https://moodle.org/plugins/auth_mcae
or this one might do it too:
Re: Cannot write to database error when setting up trigger on mdl_user
by Dan Marsden -
Number of replies: 0