Changing db password suddenly created a new user (project's slug) with no permissions for public shema. As I understand, previously it was «postgres» which has full admin permissions. So the issue is that I completely lost access to the data in my database, I tried GRANT SQL command but it's marked as «potentially dangerous».
