On Wed, 2005-05-18 at 05:36, William Shatner wrote: > Hello, > > > I am using PostgreSQL 8.0 as a data repository for a Java based system > and I now want to add users to my java program with usernames and > passwords. Is their an encrypted password field I can use in a User > Table to store passwords or what would be the best way to approach > this? > > The usernames and passwords will apply for connection to the to the > java program only. All users will be connecting to the PostgreSQL > database transparently using the same username/password stored in a > properties file to validate their java program username/passwords. The md5() function is quite useful for this. It's a one way hash function that's commonly used by many applications to create password hashes. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx