Re: [SQL] Changing user passwords

[Nagy Laszlo Zsolt , KLTE TTK pm1]

> 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