Re: Users and session ids - Mailing list pgsql-general

From Keith C. Perry
Subject Re: Users and session ids
Date
Msg-id 1071070032.3fd73b5095095@webmail.vcsn.com
Whole thread Raw
In response to Users and session ids  ("C G" <csgcsg39@hotmail.com>)
List pgsql-general
Quoting C G <csgcsg39@hotmail.com>:

> 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

Colin,

For the web, if you are running apache and mod_perl, take a look at the
PosgreSQL authentication modules on CPAN.org.  In particular, anything that
deals with "cookie tracking" or authentication with cookies would be a start.

Of coures there are similar modules/methods for the other PG supported languages
as well.


--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com

pgsql-general by date:

Previous
From: Sai Hertz And Control Systems
Date:
Subject: Re: [NOVICE] PostgreSQL Training
Next
From: Jan Wieck
Date:
Subject: Re: Wird behavour of foreign keys