Postgres Pro
Downloads
Home   >   mailing lists

Questions regarding SET option. - Mailing list pgsql-general

From Jignesh Shah
Subject Questions regarding SET option.
Date
Msg-id c11950271002220308h5d4f44f6m1ed414f2142bb174@mail.gmail.com
Whole thread Raw
Responses Re: Questions regarding SET option.  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Questions regarding SET option.  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: beulah prasanthi
Date:
Subject: helo
Next
From: beulah prasanthi
Date:
Subject: TypeCast: util.list to array type