I am currently using vault to generate database credentials.
The service itself handles migrations against the database.
I end up with tables owned by the generated vault role. the database administrator loses access to these tables and is not able to generate a new user against the same set of tables.
Any tips or ideas on how to solve this in a good way?
Advertisement
Answer
Solution is to create a trigger on create table to alter the table owner to a shared admin group.
https://www.postgresql.org/docs/9.1/sql-createtrigger.html