Details
Assignee
UnassignedUnassignedReporter
bobbobPriority
MediumComponents
Details
Details
Assignee
Unassigned
UnassignedReporter
bob
bobPriority
Components
Smart Checklist
Smart Checklist
Smart Checklist
Created March 1, 2021 at 1:22 PM
Updated February 29, 2024 at 8:54 PM
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.