Re: Generating unique session ids - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Generating unique session ids
Date
Msg-id 20060727135520.GB17440@surnet.cl
Whole thread Raw
In response to Re: Generating unique session ids  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Generating unique session ids  (Rodrigo Gonzalez <rjgonzale@gmail.com>)
Re: Generating unique session ids  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
Tom Lane wrote:

> > * Any database user is most of the time able to read function
> > bodies, so anybody who is able co connect to your database will be
> > able to get your 'secret_salt' and then predict session id's.
>
> Yeah, it's not clear where to hide the secret.

In a memfrob'ed (or something better probably) area in a C function?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Generating unique session ids
Next
From: Markus Schiltknecht
Date:
Subject: Re: Database Oid from SPI