On Mon, 27 Jan 2003, Antti Haapala wrote:
> I need this feature also. The problem with set session authorization is
> that you can always change back so it's not that secure. Actually I wanted
> to have a function that could augment the privileges of user if supplied
> the right password, which i
On Mon, 27 Jan 2003, Shridhar Daithankar wrote:
> I went thr http://candle.pha.pa.us/main/writings/pgsql/sgml/sql-set-session-
> authorization.html to get what it is. I didn't have an idea of such thing.
>
> Back to the topic, yes, pretty much except for few differences.
>
> 1) It says 'The sessi
On 27 Jan 2003 at 9:16, Tom Lane wrote:
> "Shridhar Daithankar" <[EMAIL PROTECTED]> writes:
> > Is it possible for an established connection to backend, to switch user on the
> > fly, if proper credentials are supplied?
>
> Are you looking for SET SESSION AUTHORIZATION?
I went thr http://candle
"Shridhar Daithankar" <[EMAIL PROTECTED]> writes:
> Is it possible for an established connection to backend, to switch user on the
> fly, if proper credentials are supplied?
Are you looking for SET SESSION AUTHORIZATION?
regards, tom lane
---(end
Hi all,
Recently solving a design problem for a friend, an idea crossed my mind.
Is it possible for an established connection to backend, to switch user on the
fly, if proper credentials are supplied?
If this can be done, it would avoid initialization penalty of a new conenction
and many appli
