Grants in prepare with 2 triggers on the same table
General
Escalation
General
Escalation
Description
Environment
None
Smart Checklist
Activity
Show:

Lalit Choudhary July 7, 2021 at 12:43 PM
closing as duplicate of
Duplicate
Details
Details
Smart Checklist
Open Smart Checklist
Smart Checklist

Open Smart Checklist
Created June 21, 2021 at 6:26 AM
Updated March 6, 2024 at 10:33 AM
Resolved July 7, 2021 at 12:42 PM
I can`t edit my own issues, and I marked the wrong version of percona () to fix it I create this new issue...
When using prepare and make update with prepare and have 2 triggers on this same table, then he asks of grant for not this user:
But when I use prepare:
user2 make update on table2, no table1... On table1 make INSERT triggers with definer user1:
How to recreate it?
System version:
Oracle Linux Server release 8.4
Percona Server version:
percona-server-server-8.0.23-14.1.el8.x86_64
login as root:
login as user2:
But on oldest version of percona:
percona-server-server-8.0.21-12.2.el8.x86_64
System version:
Oracle Linux Server release 8.3