Manage role permissions
Good evening! I'm currently working on a project for a client and decided to use PostgreSQL in conjunction with Neon DB. I've already created a database, but I'm running into an issue.
Three services/microservices need to communicate with the database, but I want to restrict access to only what each service needs to do. I created a role for each service and noticed that all of them have the CREATEDATABASE, CREATEROLE, and many other high-level permissions. However, they shouldn't have permission for these, so I tried to disable them.
When I tried to disable them, I received an error:
I also noticed that the default Neon user (neondb_owner) does not have the SUPERUSER permission. How can I fix this and remove these permissions?
Three services/microservices need to communicate with the database, but I want to restrict access to only what each service needs to do. I created a role for each service and noticed that all of them have the CREATEDATABASE, CREATEROLE, and many other high-level permissions. However, they shouldn't have permission for these, so I tried to disable them.
When I tried to disable them, I received an error:
I also noticed that the default Neon user (neondb_owner) does not have the SUPERUSER permission. How can I fix this and remove these permissions?
