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` co
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; CRE
> 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 'passw
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
