I need to create role users of which can only read (select) data.
I can do it for a particular schema.
But I need it to work with all existing and future schemas (existing at least). How can I do it?
GRANT select ON DATABASE mzia TO qaread;
But it says that I can’t: