Database roles does not work properly

[Martin_Davidik]

Hello, everytime i create new database, or user role, the error message is displayed. “Whoops! Assertion failed. If this keeps happening, check out status.koyeb.com.”

I created two databases and three roles. I assume (according to documentation), that only owner of the database should have access to it. But all three users have access to both databases (first user should have access to first db, second should have access to second db, and thirs user should have access to no database).

I also tried to write data to all database with all users, and data was written without any issues (this is security issue). I need separate access to database.

One user should have access only to one database (which owns).

If it is feature, that all users have full access to all database, then why there is role support…?

I believe, that this is some bug which will be solved, and I can rely on database. Now i do not trust it, and I am considering to use another managed database from different provider…

Please let me know, whether this bug will be fixed soon.
Thanks for reply in advance
Regards Martin

[David]

Hi @Martin_Davidik;

By default, the role created through Koyeb will inherit superuser permissions, giving them access to all tables of the database.

To separate access to the database, you must create roles using SQL commands after connecting to your database.

Then you can use the GRANT command to set the permission of the role for each database or table. PostgreSQL: Documentation: 17: GRANT

Regarding the frontend issue, we are investigating and we will let you know when it is fixed.

[nils]

Hello @Martin_Davidik, the “Whoops! Assertion failed” issue is now fixed.