pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedChanging user passwords
4+ messages / 3 participants
[nested] [flat]
* Changing user passwords
@ 2000-08-07 15:17 Rob van der Leek <rob@frog.nl>
0 siblings, 1 reply; 4+ messages in thread
From: Rob van der Leek @ 2000-08-07 15:17 UTC (permalink / raw)
To: pgsql-sql@hub.org <pgsql-sql@hub.org>
Hello,
Is it possible to change a user's password without using the pg_passwd
command?
For example, how does a user changes his password from the interactive
monitor?
In case you were wondering, I'm scripting an interface to a pg database
using
Perl/DBI and the "administrator" web user should be able to change the
default
password.
I'm a pg/SQL novice, yet I'm always willing to learn new things,
references to
documentation will be appreciated as much as solutions.
Apologies in advance for my ignorance.
--
Rob van der Leek
E-mail: rob@frog.nl
----------------------------
FROG Navigation Systems b.v.
Cartesiusweg 120
3534 BD Utrecht
Tel. 030-2440550
Fax. 030-2440700
http://www.frog.nl
----------------------------
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Changing user passwords
@ 2000-08-08 12:59 Nagy Laszlo Zsolt , KLTE TTK pm1 <nagylzs@dragon.klte.hu>
parent: Rob van der Leek <rob@frog.nl>
0 siblings, 1 reply; 4+ messages in thread
From: Nagy Laszlo Zsolt , KLTE TTK pm1 @ 2000-08-08 12:59 UTC (permalink / raw)
To: Rob van der Leek <rob@frog.nl>; +Cc: pgsql-sql@hub.org <pgsql-sql@hub.org>
> Is it possible to change a user's password without using the pg_passwd
> command?
> For example, how does a user changes his password from the interactive
> monitor?
See the following commands:
CREATE USER
ALTER USER
CREATE GROUP
ALTER GROUP
For example:
ALTER USER user1 WITH PASSWORD 'password1';
Please note thatuser passwords cannot be changed in a transaction. ( 7.0.2
)
Laci 1.0
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Changing user passwords
@ 2000-08-08 13:38 Rob van der Leek <rob@frog.nl>
parent: Nagy Laszlo Zsolt , KLTE TTK pm1 <nagylzs@dragon.klte.hu>
0 siblings, 1 reply; 4+ messages in thread
From: Rob van der Leek @ 2000-08-08 13:38 UTC (permalink / raw)
To: ; +Cc: pgsql-sql@hub.org <pgsql-sql@hub.org>
A question about the ALTER USER command I couldn't find in the
standard documentation:
- How do I assign an 'undefined' password?
ALTER USER nobody WITH PASSWORD "";
works, but doesn't assign an undefined password to nobody (like the
`pg_passwd nobody` command would do).
DROP USER nobody; CREATE USER nobody;
doesn't do the job either.
And why does the ALTER USER command operates on pg_shadow instead of
pg_passwd? (or is this configurable?)
rob.
-
"Nagy Laszlo Zsolt , KLTE TTK pm1" wrote:
>
> > Is it possible to change a user's password without using the pg_passwd
> > command?
> > For example, how does a user changes his password from the interactive
> > monitor?
>
> See the following commands:
>
> CREATE USER
> ALTER USER
> CREATE GROUP
> ALTER GROUP
>
> For example:
>
> ALTER USER user1 WITH PASSWORD 'password1';
>
> Please note thatuser passwords cannot be changed in a transaction. ( 7.0.2
> )
>
> Laci 1.0
--
Rob van der Leek
E-mail: rob@frog.nl
----------------------------
FROG Navigation Systems b.v.
Cartesiusweg 120
3534 BD Utrecht
Tel. 030-2440550
Fax. 030-2440700
http://www.frog.nl
----------------------------
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Changing user passwords
@ 2000-08-08 15:53 Bernie Huang <bernie.huang@ec.gc.ca>
parent: Rob van der Leek <rob@frog.nl>
0 siblings, 0 replies; 4+ messages in thread
From: Bernie Huang @ 2000-08-08 15:53 UTC (permalink / raw)
To: Rob van der Leek <rob@frog.nl>; +Cc: pgsql-sql@hub.org <pgsql-sql@hub.org>
Rob van der Leek wrote:
> A question about the ALTER USER command I couldn't find in the
> standard documentation:
>
> - How do I assign an 'undefined' password?
>
> ALTER USER nobody WITH PASSWORD "";
>
> works, but doesn't assign an undefined password to nobody (like the
> `pg_passwd nobody` command would do).
>
> DROP USER nobody; CREATE USER nobody;
>
> doesn't do the job either.
>
>
There is no space between:
eg; createuser whoever; dropuser whoever;
- Bernie
Attachments:
bernie.huang.vcf (text/x-vcard, 314B) download
begin:vcard
n:Huang;Bernie
tel;fax:(604)664-9195
tel;work:(604)664-9172
x-mozilla-html:TRUE
org:Environment Canada;Standards and Technology Services
adr:;;700-1200 West 73 Ave.;Vancouver;BC;V6P 6H9;Canada
version:2.1
email;internet:bernie.huang@ec.gc.ca
title:Programmer
x-mozilla-cpt:;0
fn:Bernie Huang
end:vcard
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2000-08-08 15:53 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-08-07 15:17 Changing user passwords Rob van der Leek <rob@frog.nl>
2000-08-08 12:59 ` Nagy Laszlo Zsolt , KLTE TTK pm1 <nagylzs@dragon.klte.hu>
2000-08-08 13:38 ` Rob van der Leek <rob@frog.nl>
2000-08-08 15:53 ` Bernie Huang <bernie.huang@ec.gc.ca>
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