how can admin role can change user/role's password.

Question

as a data admin, I created a role and role's password and gave it to user. user forgot his password. I am not sure where I can change password for a role. this role created a table in his own schema where I do not have access to. Now I cannot delete this role. HOw can I reset this role's password.

Answer 1

Hi Grover, Jyoti •,

Welcome to Microsoft Q&A forum.

As I understand, you are trying to reset password for Azure Database for PostgreSQL Flexible Server.

You can change the administrator role's password using the Azure portal.

Select your server in the Azure portal. In the Overview window select Reset password.

Enter a new password and confirm the password. The textbox will prompt you about password complexity requirements.

Through Azure CLI, you can change the administrator role's password with this command:

az postgres server update --resource-group myresourcegroup --name mydemoserver --admin-password <new-password>

References: https://learn.microsoft.com/en-us/azure/postgresql/single-server/how-to-manage-server-cli

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-manage-server-portal

Hope this helps. Let us know if you have further queries.

Thanks

Answer 2

@Grover, Jyoti

Please follow below document and command

https://www.postgresql.org/docs/8.0/sql-alteruser.html

It seems you are looking for ALTER USER -- change a database user account.

ALTER USER name RESET parameter

Thank you!