SO and Internet contains a lot of answers to question how to create read only user (for example see this article), BUT all of them promote the following way:
- Create user
- Grant
USAGE
privilege to all existing schemas - Grant
SELECT
privilege to all existing tables in all existing schemas - Grant default
SELECT
privilegie to all tables (which can be created in the future) for all existing schemas
But what to do if some schemas can be created in the future too?
I mean I want to grant read only permissions to these schemas (and tables in these schemans) created in the future without any additional configuration. Is it possible?