From: | Rob van der Leek <rob(at)frog(dot)nl> |
---|---|
To: | |
Cc: | "pgsql-sql(at)hub(dot)org" <pgsql-sql(at)hub(dot)org> |
Subject: | Re: Changing user passwords |
Date: | 2000-08-08 13:38:57 |
Message-ID: | 39900D71.170A98BD@frog.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)frog(dot)nl
----------------------------
FROG Navigation Systems b.v.
Cartesiusweg 120
3534 BD Utrecht
Tel. 030-2440550
Fax. 030-2440700
http://www.frog.nl
----------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Keith Wong | 2000-08-08 14:29:50 | returning a recordset with pl/pgsql |
Previous Message | Nagy Laszlo Zsolt , KLTE TTK pm1 | 2000-08-08 12:59:20 | Re: Changing user passwords |