We're managing about 200 instances of postgres on Amazon RDS. The problem that we're constantly experiencing is that our "DBA" accounts can't access stuff. Basic stuff. Tables, views, etc.
Is there some kind of event-based automation, call it a trigger or so, that can handle this automatically? Manual grants are not an option - automation is the only possible solution.
Whenever a new database is created, a new schema is created, or anything and everything that is created - the "DBA" users are granted access to it.
What solutions are there for postgres 9.6 or 10?
Example use case:
RDS instance "dev1" has 10 postgres databases
So we go in and grant access to everything in those 10 databases to our dbauser
Next week, a new deployment takes place that creates an 11th database
Following that we get a request to export a table from that 11th database and our user doesn't have access to it.
We want to eliminate that.