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

Re: Simple way to manage users with JDBC/Servlets?

From: Roland Walter <rwa(at)mosaic-ag(dot)com>
To: Peter Neu <peter(dot)neu(at)gmx(dot)net>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Simple way to manage users with JDBC/Servlets?
Date: 2006-07-27 09:17:36
Message-ID: 44C884B0.40007@mosaic-ag.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Peter Neu schrieb:
>
>  
>
> Can the password be auto created by postgresql and converted in md5?
>
>  
>
I would try to declare a server side function that generates the 
password from the name and set a default on the password column that 
uses this function.

There is a md5() function declared in PostgreSQL.

It is mentioned in the documentation for 8.1:

http://www.postgresql.org/docs/8.1/interactive/functions-binarystring.html

But not in the documentation for 7.4, but it is there. Tried it on 
7.4.13 with

select md5('admin001')

and got

4eef1e1ea34879a2ae60c60815927ed9

BTW, you should update your database, at least to 7.4.13. Better would 
be 8.1.x.

Regards,
Roland.

-- 
Roland Walter                   mailto: rwa (at) mosaic-ag (dot) com
MOSAIC SOFTWARE AG               phone: +49 (0) 22 25 / 88 2-44 9
Am Pannacker 3                     fax: +49 (0) 22 25 / 88 2-20 1
D-53340 Meckenheim                http://www.mosaic-ag.com



Die in dieser E-Mail enthaltenen Nachrichten und Anhaenge sind ausschliesslich 
fuer den bezeichneten Adressaten bestimmt. Sie koennen rechtlich geschuetzte, 
vertrauliche Informationen enthalten. Falls Sie nicht der bezeichnete Empfaenger
oder zum Empfang dieser E-Mail nicht berechtigt sind, ist die Verwendung,
Vervielfaeltigung oder Weitergabe von Nachrichten und Anhaengen untersagt.
Falls Sie diese E-Mail irrtuemlich erhalten haben, informieren Sie bitte 
unverzueglich den Absender und vernichten Sie die E-Mail.

This e-mail message and any attachment are intended exclusively for the named 
addressee. They may contain confidential information which may also be protected 
by professional secrecy. Unless you are the named addressee (or authorised to
receive for the addressee) you may not copy or use this message or any attachment
or disclose the contents to anyone else. If this e-mail was sent to you by mistake
please notify the sender immediately and delete this e-mail.

In response to

Responses

pgsql-jdbc by date

Next:From: Roland WalterDate: 2006-07-27 09:25:32
Subject: Re: Simple way to manage users with JDBC/Servlets?
Previous:From: Peter NeuDate: 2006-07-27 08:44:58
Subject: Simple way to manage users with JDBC/Servlets?

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