On Fri, 24 May 2002, Arindam Haldar wrote:
> i want to authenticate web users from postgrsql for which i created a
> table having,among others, username & password... is there any data
> types where password can be stored encrypted ?.. at present am vsing
> varchar(16) but i c one (administrator) can read the password. i didnt
> find any data type specifying encrypted type !...
mod_auth_pgsql for Apache has an option to read encrypted passwords. You
can choose betwen plain, md5 an crypt. But it doesn't bother how you
inserted it into the table. Seems that you have to encrypt it with your
favourite tool before you insert it. In the table it's just a
text/varchar type AFAIK.
--
PGP/GPG Key-ID:
http://blackhole.pca.dfn.de:11371/pks/lookup?op=get&search=0xB5A1AFE1