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;

CodePudding user response：

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.