Skip site navigation (1) Skip section navigation (2)

Re: Error Writing/Reading Encrypted Values

From: Keith Gray <keith(at)heart(dot)com(dot)au>
To: cnliou(at)eurosport(dot)com
Cc: ODBC <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Error Writing/Reading Encrypted Values
Date: 2002-01-15 01:31:20
Message-ID: 3C438668.8B6AA8DE@heart.com.au (view raw or flat)
Thread:
Lists: pgsql-odbc
cnliou(at)eurosport(dot)com wrote:
> 
> 
> Problem happens when the decryption routine (running
> in Windoz) tries to decrypt the encrypted password
> retrieved from postgresql - it occasionally succeeds
> but hangs most of the time.

I would never use decrypt of password...
One should always compare if 

encrypt(attempt) = encrypt(password)

...then you do not need to decrypt - better security

-- 
Keith Gray

Technical Development Manager
Heart Consulting Services P/L
mailto:keith(at)heart(dot)com(dot)au

In response to

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2002-01-15 04:34:51
Subject: Re: Rep:Re: Error Writing/Reading Encrypted Values
Previous:From: Curtis GallowayDate: 2002-01-15 00:59:41
Subject: Bad SQL generated by application

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group