Is there a way to change a database owner to another role?
Neon✅Answered🐘Postgres❓QuestionI am pretty new to postgres and kind of shot myself in my own foot.
What I did was create an owner role per database, but it makes far more sense to keep one db_admin role which is owner of all of them and then create database specific roles (using SQL) with just the permissions they need for their respective uses cases within the app.
So my question is: Is there a way to transfer ownership of a database to another role in neon?
I have tried:
as the (generic postgres) documentation says from neon:
https://neon.com/postgresql/postgresql-administration/postgres-change-database-owner
but I keep hitting errors:
From what I can put together, the issue is that the db_admin role is created through the "Neon Console" under Roles & Databases using the neon_superuser role. This means that whenever I login with any of the roles I do have access to, I don't have enough permission to transfer ownership from that role to db_admin.
If you need any other info, pls let me know. Thx in advance.
What I did was create an owner role per database, but it makes far more sense to keep one db_admin role which is owner of all of them and then create database specific roles (using SQL) with just the permissions they need for their respective uses cases within the app.
So my question is: Is there a way to transfer ownership of a database to another role in neon?
I have tried:
ALTER DATABASE develop OWNER TO db_admin;as the (generic postgres) documentation says from neon:
https://neon.com/postgresql/postgresql-administration/postgres-change-database-owner
but I keep hitting errors:
ERROR: must be able to SET ROLE "db_admin"permission denied to grant role "db_admin"From what I can put together, the issue is that the db_admin role is created through the "Neon Console" under Roles & Databases using the neon_superuser role. This means that whenever I login with any of the roles I do have access to, I don't have enough permission to transfer ownership from that role to db_admin.
If you need any other info, pls let me know. Thx in advance.
