pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rob van der Leek <rob@frog.nl>
Cc: pgsql-sql@hub.org <pgsql-sql@hub.org>
Subject: Re: Changing user passwords
Date: Tue, 08 Aug 2000 15:38:57 +0200
Message-ID: <39900D71.170A98BD@frog.nl> (raw)
References: <Pine.GSO.4.10.10008081457470.20170-100000@dragon>

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
----------------------------



view thread (4+ messages)  latest in thread

Message-ID: <39900D71.170A98BD@frog.nl>
Permalink:  ../39900D71.170A98BD@frog.nl/
Also on:    postgresql.org/message-id/39900D71.170A98BD@frog.nl

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: rob@frog.nl, pgsql-sql@hub.org
  Subject: Re: Changing user passwords
  In-Reply-To: <39900D71.170A98BD@frog.nl>
  References: <Pine.GSO.4.10.10008081457470.20170-100000@dragon> <39900D71.170A98BD@frog.nl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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