precheck triggers definers, ensure same definer or abort

Description

ptosc kindly tries to preserve triggers with original definer. That's great.
But without SUPER privilege (ex: RDS), it is not possible to define triggers on behalf of another user.

We actually run ptosc with a user that is trusted to DROP/CREATE triggers.
So we'd like a way to restore triggers without using the definer to avoid the failure.

We don't mind if this is a 'beware definers will change!' option. We can opt-in with on the commandline if necessary to protect the casual ptosc users.

Environment

None

Smart Checklist

Activity

Show:

Lalit Choudhary April 29, 2021 at 2:30 PM

Hi Bob,

Thank you for the Improvement request.

Details

Assignee

Reporter

Priority

Components

Smart Checklist

Created March 1, 2021 at 1:22 PM
Updated February 29, 2024 at 8:54 PM