pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
password encryption
3+ messages / 3 participants
[nested] [flat]

* password encryption
@ 2000-07-21 16:08 Silesky Marketing Inc, Support <support@silesky.com>
  2000-07-21 17:30 ` Re: [SQL] password encryption Roderick A. Anderson <raanders@altoplanos.net>
  0 siblings, 1 reply; 3+ messages in thread

From: Silesky Marketing Inc, Support @ 2000-07-21 16:08 UTC (permalink / raw)
  To: pgsql-sql; pggeneral <pgsql-general@postgresql.org>

Hello,

I want to encrypt passwords with Postgresql the way mySQL does it with :

UPDATE user SET Password=PASSWORD('new_password') WHERE user='root';

How can I do that ?

Thanks a lot,

Laurent





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [SQL] password encryption
  2000-07-21 16:08 password encryption Silesky Marketing Inc, Support <support@silesky.com>
@ 2000-07-21 17:30 ` Roderick A. Anderson <raanders@altoplanos.net>
  2000-07-24 22:37   ` Re: password encryption Aaron Sethman <androsyn@ratbox.org>
  0 siblings, 1 reply; 3+ messages in thread

From: Roderick A. Anderson @ 2000-07-21 17:30 UTC (permalink / raw)
  To: Silesky Marketing Inc, Support <support@silesky.com>; +Cc: pgsql-sql; pggeneral <pgsql-general@postgresql.org>

On Fri, 21 Jul 2000, Silesky Marketing Inc, Support wrote:

> Hello,
> 
> I want to encrypt passwords with Postgresql the way mySQL does it with :
> 
> UPDATE user SET Password=PASSWORD('new_password') WHERE user='root';

Check out the ALTER command.

ALTER USER username
    [ WITH PASSWORD 'password' ]
    [ CREATEDB | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ]
    [ VALID UNTIL 'abstime' ]


Rod
--
Roderick A. Anderson
raanders@altoplanos.net               Altoplanos Information Systems, Inc.
Voice: 208.765.6149                            212 S. 11th Street, Suite 5
FAX: 208.664.5299                                  Coeur d'Alene, ID 83814




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: password encryption
  2000-07-21 16:08 password encryption Silesky Marketing Inc, Support <support@silesky.com>
  2000-07-21 17:30 ` Re: [SQL] password encryption Roderick A. Anderson <raanders@altoplanos.net>
@ 2000-07-24 22:37   ` Aaron Sethman <androsyn@ratbox.org>
  0 siblings, 0 replies; 3+ messages in thread

From: Aaron Sethman @ 2000-07-24 22:37 UTC (permalink / raw)
  To: Roderick A. Anderson <raanders@altoplanos.net>; +Cc: Silesky Marketing Inc, Support <support@silesky.com>; pgsql-sql; pggeneral <pgsql-general@postgresql.org>

I think what he was looking for was more along the lines of a generic sql
function that hashes a string, and not to update the system tables.

I actually wrote a replacement for the mysql PASSWORD() function that is
actually compatible with the hashing that mysql uses.  If you would like a
copy of this function just let me know so I can extract it out of the a
bunch of other functions.

Aaron

 On Fri, 21 Jul 2000, Roderick A. Anderson wrote:

> On Fri, 21 Jul 2000, Silesky Marketing Inc, Support wrote:
> 
> > Hello,
> > 
> > I want to encrypt passwords with Postgresql the way mySQL does it with :
> > 
> > UPDATE user SET Password=PASSWORD('new_password') WHERE user='root';
> 
> Check out the ALTER command.
> 
> ALTER USER username
>     [ WITH PASSWORD 'password' ]
>     [ CREATEDB | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ]
>     [ VALID UNTIL 'abstime' ]
> 
> 
> Rod
> --
> Roderick A. Anderson
> raanders@altoplanos.net               Altoplanos Information Systems, Inc.
> Voice: 208.765.6149                            212 S. 11th Street, Suite 5
> FAX: 208.664.5299                                  Coeur d'Alene, ID 83814
> 
> 
> 




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2000-07-24 22:37 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-07-21 16:08 password encryption Silesky Marketing Inc, Support <support@silesky.com>
2000-07-21 17:30 ` Roderick A. Anderson <raanders@altoplanos.net>
2000-07-24 22:37   ` Aaron Sethman <androsyn@ratbox.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox