Re: [HACKERS] Switching connection on the fly

2003-01-27 Thread Antti Haapala
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

Re: [HACKERS] Switching connection on the fly

2003-01-27 Thread Antti Haapala
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

Re: [HACKERS] Switching connection on the fly

2003-01-27 Thread Shridhar Daithankar
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

Re: [HACKERS] Switching connection on the fly

2003-01-27 Thread Tom Lane
"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