GRANT INHERIT PRIVILEGES TO user
"Execute invoker's rights procedures or functions owned by the grantee with the privileges of the invoker when the invoker is the user on whom this privilege is granted."
If there is someone who can translate in plain english the sentence above, please contact me ASAP, I read it a dozen times and still can't make a sense out of it.
UPDATED 2020/2/13: in the comments a link to a useful article explaining the issue in detail with examples.
