Hello All,
I have been writing a function with SECURITY DEFINER enabled. Basically, I am looking for ways to override the users SET option settings while executing my function to prevent the permissions breach. For example, to override "SET search_path", I am setting search path in my function before executing anything. Could any one please tell me what could be other SET options that I should take care?
Moreover, how to revert back those settings just before returning from my function?
Thanks, Jack