Re: Changing user passwords - Mailing list pgsql-sql

From Bernie Huang
Subject Re: Changing user passwords
Date
Msg-id 39902D01.A2C1A3B8@ec.gc.ca
Whole thread Raw
In response to Re: Changing user passwords  ("Nagy Laszlo Zsolt , KLTE TTK pm1" <nagylzs@dragon.klte.hu>)
List pgsql-sql
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

Attachment

pgsql-sql by date:

Previous
From: Keith Wong
Date:
Subject: returning a recordset with pl/pgsql
Next
From: Ang Chin Han
Date:
Subject: Re: Functions too slow, even with iscachable?