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
databaseautomatically. 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.klaver@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
“permissiondenied”.
>> 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.klaver@aklaver.com