Re: Invoking user of the function with SECURITY DEFINER

Looked like a bug. > 25 нояб. 2018 г., в 14:50, Madan Kumar написал(а): > > Got it.. > In my case i was getting session_user in declare section and trying to > validate later which always resulted in the function owner. > DECLARE > user text := SESSION_USER; > > So using it within the B

Re: Invoking user of the function with SECURITY DEFINER

Got it.. In my case i was getting session_user in declare section and trying to validate later which always resulted in the function owner. DECLARE user text := SESSION_USER; So using it within the BEGIN; ...; END; clause worked for me. Thanks. Warm Regards, Madan Kumar K

Re: Invoking user of the function with SECURITY DEFINER

Laurenz Albe wrote: > Madan Kumar wrote: > > How to get the user who is invoking the function with SECURITY DEFINER? > > When we define the function to be SECURITY DEFINER, it will execute in the > > context of the user who created it. Let's say I've given execute permission > > for this function

Re: Invoking user of the function with SECURITY DEFINER

Madan Kumar wrote: > How to get the user who is invoking the function with SECURITY DEFINER? > When we define the function to be SECURITY DEFINER, it will execute in the > context of the user who created it. Let's say I've given execute permission > for this function to other users and wish to kno