Re: Can db user change own password?

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(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com