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
USAGEprivilege to all existing schemas
SELECTprivilege to all existing tables in all existing schemas
- Grant default
SELECTprivilegie 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?