On 10/20/21 08:07, Toomas wrote:
> 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.
I'm not understanding. You will need to sketch this out:
1) Connection parameters for log in with <user_name>.
2) On log in the output from: select session_user, current_user;
3) Define '...set as owner of database automatically'.
>
> 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
>
--
Adrian Klaver
adrian.klaver@aklaver.com