Allow resetting password for a pg role via mathesar

[Anish9901]

Description

To create a postgres login role via mathesar or psql, a role name and password are required. In mathesar, users must provide the password when configuring roles to be used for different database servers.

Currently mathesar doesn't validate the password when it is stored, which could result in an incorrect password being saved. Dropping the role entirely and creating a new one is not a viable solution either, as there may be database objects dependent on the role.

Additionally, if a user is connecting their preexisting db to mathesar and has forgotten the password for one of their roles, the only way to reset it is by running a command like ALTER USER user_name WITH PASSWORD 'new_password'; through psql.

Proposed Solution

There should be a way to reset the password for a login role via mathesar.

There are some implications of resetting the password that we'll need to think through:

• What should happen if the password of a configured role in mathesar is reset? Should the admin need to put in the password for those roles again? Or should we configure them automatically similar to what's proposed in Automatically configure new roles created via mathesar #4118
• Should we allow mathesar admins to use a different role for resetting the password for a role similar to how we do it for disconnecting db?

[kgodey]

Can we please add some details to this, @Anish9901