Re: Can db user change own password?

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