Manage Postgres roles in the dashboard and CLI
You can now reset role credentials and reassign database objects from the dashboard and CLI.
In the dashboard, you'll find Reset credentials and Reassign objects options on the Role management page. Reset credentials generates a new password for an existing role. Reassign objects transfers ownership of database objects from one role to another.
We've also added two new CLI commands to manage roles in Postgres databases:
pscale role reset --org <org> <database> <branch> <role-id>— Resets the password for a role after prompting for confirmation. Returns the role object with the new password.pscale role reassign --org <org> <database> <branch> <donor> --successor <recipient>— Assigns all objects owned by the donor role to the recipient role.
Read the roles documentation for more details on managing Postgres roles.