use Perl

• That's for CREATE, not running (Score:2)

  by autarch (914)

  Reading the docs, it seems like it's just for creating the triggers, not executing them.
  • Re: (Score:2)

    by Ovid (2709)

    Sorry, but not quite correct. It's a pain to read through, but this is the killer:

    At trigger activation time, privileges are checked against the DEFINER user. This user must have these privileges:

    • The TRIGGER privilege. (SUPER prior to MySQL 5.1.6.)
    • The SELECT privilege for the subject table if references to table columns occur via OLD.col_name or NEW.col_name in the trigger definition.
    • The UPDATE privilege for the subject table if table columns are targets of SET NEW.col_name = value assignments in the trigger definition.
    • Whatever other privileges normally are required for the statements executed by the trigger.

    That was not fun to track down, but there ya go.
    • Re:That's for CREATE, not running (Score:2)

      by TeeJay (2309) on 2009.02.27 14:33 (#67648) Homepage Journal

      Have you tested that? .. as it still seems to apply the privilege tests to the user that defined the trigger, rather than the user invoking it.

      --
      
      @JAPH = qw(Hacker Perl Another Just);
      print reverse @JAPH;

      Reply to This

      Parent