Hi Adrian, Thank you for your help. The issue was that when user logged into database his session_user user was set as owner of database automatically. User had success to change password when session_user = current_user was set before.
BR, Toomas > On 20. Oct 2021, at 17:45, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > > On 10/20/21 07:38, Toomas wrote: >> Hi, >> Is there any possibilities that db user can change own password? >> There is no difference does the user uses ALTER command or \password >> meta-command, result is the same - response is “permission denied”. >> dbname=> \password >> Enter new password: >> Enter it again: >> ERROR: permission denied > > Works for me, you will need to supply more information: > > 1) Postgres version? > > 2) User you are connecting as? > > 3) Output of \du <user_name> > >> BR, >> Toomas > > > -- > Adrian Klaver > adrian.kla...@aklaver.com
