Jignesh Shah wrote: > 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? You can use the SET clause of CREATE FUNCTION which does exactly what you want. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general