Re: Can db user change own password? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Can db user change own password?
Date
Msg-id 62f56a19-0504-4d7b-5f73-b10e8206642a@aklaver.com
Whole thread Raw
In response to Can db user change own password?  (Toomas <toomas.kristin@gmail.com>)
Responses Re: Can db user change own password?
List pgsql-general
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



pgsql-general by date:

Previous
From: Toomas
Date:
Subject: Can db user change own password?
Next
From: Joel Perren
Date:
Subject: Selectivity and row count estimates for JSONB columns