Search code examples
postgresqlchange-password

What role/policy I can map for PostgreSQL USER so that he can change his existing password

What role/policy/command I can use/map for PostgreSQL USER so that he can change on his own existing password?

CREATE USER abcd with ENCRYPTED PASSWORD 'P@wd123!';
GRANT rds_iam, app_readonly TO abcd;
Solution

  • There is a dialog to change the password of the currently connected user securely with pgAdmin4: Select the server in the tree view, then select "Object" / "Change Password..." from the menu.