Users and session ids - Mailing list pgsql-general

From C G
Subject Users and session ids
Date
Msg-id Law12-F70zDzC4AGBt600023b8d@hotmail.com
Whole thread Raw
Responses Re: Users and session ids
Re: Users and session ids
Re: Users and session ids
List pgsql-general
Dear All,

I wonder if anyone can advise me with this problem.

1. A user logs into the database (through web, webservice, some other piece
of software) - connect(user="joe",passwd="blogs")
2. We generate a random session key which will expire in 1 hour. Put this in
table (user, SessKey, time).
3. Give key to user.
4. User wants to do something else, so passes us the session key.
5. How do we use this session key to log the user into the database, i.e.
how do we get the username and passwd to enable:
connect(user="joe",passwd="blogs").

Many thanks

Colin

_________________________________________________________________
Tired of 56k? Get a FREE BT Broadband connection
http://www.msn.co.uk/specials/btbroadband


pgsql-general by date:

Previous
From: Joel Rodrigues
Date:
Subject: Re: spelling errors in query terms
Next
From: "Uwe C. Schroeder"
Date:
Subject: Re: Users and session ids