-----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 user. On Wednesday 10 December 2003 01:55 am, 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, 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org - -- UC - -- Open Source Solutions 4U, LLC 2570 Fleetwood Drive Phone: +1 650 872 2425 San Bruno, CA 94066 Cell: +1 650 302 2405 United States Fax: +1 650 872 2417 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE/1vZ3jqGXBvRToM4RAv+pAJ0bzCNwhsHxoCk36lXbppy8oQ7C6QCcD4H5 GKM2nyxIaOgp98liPyjKk8w= =qF5p -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
