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.
2 comments:
I think I got it. The problem is the second half of the sentence: "with the privileges of the invoker when the invoker is the user on whom this privilege is granted".
This is kind of redundant, like "whith the priveleges of JOE when JOE is the person privileged."
So, I belived they simple tried to say "Execute Joe right's on procedures or functions owned by Mac".
Where's my prize? :)
A useful article with examples
Post a Comment