Tables created after privileges are granted do not have the right privileges set

[alv-lop]

In a PostgreSQL database, if any tables are created after the manage-postgres-user.py has run, those tables will not have the same privileges as the ones existing prior to this run.

ALTER DEFAULT PRIVILEGES needs to be added as an extra statement once the privileges have been set so that the same behaviour remains on newly created tables.

References:

• https://www.postgresql.org/docs/13/ddl-priv.html
• https://www.postgresql.org/docs/current/sql-alterdefaultprivileges.html