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.klaver@xxxxxxxxxxx> 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.klaver@xxxxxxxxxxx
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
