Server: MySQL 5.7.14 I am following the Suggestion 1 suggested here https://dba.stackexchange.com/a/109416/126860
I am trying to find out which user called the stored procedure. But since I am also using a definer. The
CURRENT_USER(); function returns the "definer" user name.
I have tried using
SHOW PROCESSLIST; to find out who is running the stored procedure. but it doesn't show stored procedures as a separate process.
Is there a way to find the actual user who invoked the stored procedure.