From: | Bernie Huang <bernie(dot)huang(at)ec(dot)gc(dot)ca> |
---|---|
To: | Rob van der Leek <rob(at)frog(dot)nl> |
Cc: | "pgsql-sql(at)hub(dot)org" <pgsql-sql(at)hub(dot)org> |
Subject: | Re: Changing user passwords |
Date: | 2000-08-08 15:53:37 |
Message-ID: | 39902D01.A2C1A3B8@ec.gc.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 | Content-Type | Size |
---|---|---|
bernie.huang.vcf | text/x-vcard | 315 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Ang Chin Han | 2000-08-09 06:50:29 | Re: Functions too slow, even with iscachable? |
Previous Message | Keith Wong | 2000-08-08 14:29:50 | returning a recordset with pl/pgsql |