In this article, we will see how to reset password for user in Azure PostgreSQL server.
We can reset password for a user in Azure PostgreSQL same as do for standard PostgreSQL server. We have two methods:
1. GUI i.e. using pgadmin tool
2. By running alter user/role command.
1. Reset password for user in Azure PostgreSQL server by using pgadmin
1. Open pgadmin
2. Go to Logins/Group Roles.
3. Right click on a user to reset the password. Then select properties.
4. Then click on definition tab and type the password as highlighted below.
5. Then, click on save.
1. Reset password for user in Azure PostgreSQL server by using pgadmin
Open query tool or connect Azure PostgreSQL from terminal or command prompt, then run the following command to change the password for the user ‘james,
alter user james with password 'James@321';
