Re: Simple way to manage users with JDBC/Servlets? - Mailing list pgsql-jdbc

From Roland Walter
Subject Re: Simple way to manage users with JDBC/Servlets?
Date
Msg-id 44C8868C.8050001@mosaic-ag.com
Whole thread Raw
In response to Simple way to manage users with JDBC/Servlets?  ("Peter Neu" <peter.neu@gmx.net>)
List pgsql-jdbc
Roland Walter schrieb:
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.

Bullshit, the documentation is here:

http://www.postgresql.org/docs/7.4/interactive/functions-string.html




-- 
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.

pgsql-jdbc by date:

Previous
From: "Peter Neu"
Date:
Subject: Simple way to manage users with JDBC/Servlets?
Next
From: Roland Walter
Date:
Subject: Re: Simple way to manage users with JDBC/Servlets?