From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Toomas <toomas(dot)kristin(at)gmail(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Can db user change own password? |
Date: | 2021-10-20 15:22:42 |
Message-ID: | e1647dd4-3801-1ccd-f452-910aec961060@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 database automatically. 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(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
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Vijaykumar Jain | 2021-10-20 15:43:13 | Re: Can db user change own password? |
Previous Message | Toomas | 2021-10-20 15:07:49 | Re: Can db user change own password? |