Re: [GENERAL] Users and session ids

2003-12-11 Thread Shridhar Daithankar
C G wrote: 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, SessK

Re: [GENERAL] Users and session ids

2003-12-10 Thread Uwe C. Schroeder
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 You've got to have some kind of "middleware". Apache, custom, whatever. Basically this piece of middleware gets the session key. Have the middleware (using a common login) retrieve the ser (and password) drom the database table and authenticate the u

[GENERAL] Users and session ids

2003-12-10 Thread C G
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