We've just rolled out some basic UI to manage database user/role assignments for managed databases.
It's very bare-bones at the moment, but here's how it works:
For MariaDB, you can assign databases to a user:
- Click the edit icon for your MariaDB user at https://my.opalstack.com/mariausers/
- Select the databases that the user should have access to. To select/deselect multiple users hold the CTRL key (CMD on a Mac) as you click.
- Click Save.
PostgreSQL is a bit different - there, you can change the owner of a database:
- Click the edit icon for your PostgreSQL database at https://my.opalstack.com/psqldbs/
- Select the owner of the database via the dropdown list.
- Click Save.
We'll add more features to this and improve the UI as we go forward.
Please try it out and let me know what you think, thanks!
