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.
In this article, we will see how to find list of users in Azure PostgreSQL. We can get list of users by querying against pg_user view and by expanding Login/Role Groups in pgadmin tool.
In this article, we will see how to install PostgreSQL 13 on Redhat.
PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.
In this article, we will see how to change PostgreSQL User Password with syntax and examples. We can change PostgreSQL User password by using alter database command.
Syntax to change PostgreSQL User/Role password:
alter user user_name with password 'NewPASSWORD'
1. Create User in PostgreSQL server.
CREATE USER karunakar with password 'karunakar@123';
2. Now change the password of PostgreSQL user using below command.
alter user karunakar with password 'admin@123';
With these steps we can change PostgreSQL User password in PgAdmin.