On Wed, 2024-06-26 at 10:35 +0200, Dominique Devienne wrote: > So I have two questions: > 1) Is there any way to know the current_role of the caller of a > DEFINER function. I fear the answer is no, but better be sure from > experts here. > 2) Why isn't there a way to obtain the above? What harm would it be? Just te be certain, let me ask a question back: If a SECURITY DEFINER function calls another SECURITY DEFINER function, which role would you like to get: 1. the invoker that called the first function 2. the owner of the first function (which is the user that called the second function) Yours, Laurenz Albe
