Re: Password safe web application with postgre - Mailing list pgsql-general

From Bohdan Linda
Subject Re: Password safe web application with postgre
Date
Msg-id 20080515163210.GA2724@bafster.baflabs.org
Whole thread Raw
In response to Re: Password safe web application with postgre  (Steve Manes <smanes@magpie.com>)
Responses Re: Password safe web application with postgre  (Steve Manes <smanes@magpie.com>)
List pgsql-general
Hello,

thank you everyone for the answers. I went through and I forgot add one
thing. The web-app is frontend, thus basically PL/PGSQL launcher and all
changes are audited, so common login is unwelcome.

On Thu, May 15, 2008 at 05:40:49PM +0200, Steve Manes wrote:
> I keep the user's login credentials in a TripleDES-encrypted,
> non-persistent cookie, separate from session data.
>

This is the approach I am/will be heading to. Having the cookie with login
and password encrypted on user side, HTTPS connection, and what was said
in previous emails about not storing credentials in cookies any ideas of
weak sides?  Moreover if parts of decryption keys will be unique to the
sessions and stored in session on a server?

PS. Appologies for going slightly OT as this is becoming more general than
pgsql.

Thank you,
Bohdan



pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Password safe web application with postgre
Next
From: "Jasbinder Bali"
Date:
Subject: DB Locks