Grants in prepare with 2 triggers on the same table

Description

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

 

Environment

None

Smart Checklist

Activity

Show:

Lalit Choudhary July 7, 2021 at 12:43 PM

closing as duplicate of

Duplicate

Details

Assignee

Reporter

Affects versions

Priority

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