pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedpassword 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