We've setup an AWS Database Migration Service which migrates schema and tables from multiple sources.
The rule for migrating from source can be a wildcard on schema, meaning a schema could 'pop up' arbitrarily as it is created in the source.
From all the various granting of privileges I've seen in PostgreSQL, all seem to specify a specific schema, or loops through each existing schema.
Is there not a way to grant certain privileges to every current and future schema in a given database?
Ideally something like this would be great:
ALTER DEFAULT PRIVILEGES FOR ROLE my_role IN SCHEMA "*" GRANT SELECT ON TABLES TO my_role;
I'm aware the super_user role can be granted to a user to make this happen, but that seems awfully dirty for someone who should only have read permissions.
Appreciate the help.