ALTER DEFAULT PRIVILEGES IN SCHEMA XXX GRANT SELECT ON TABLES TO "user";
Does a person know how to give privileges to a SuperUser role so that when he creates a new table, whether in the public schema or another schema, the table will be by default visible,
ALTER DEFAULT PRIVILEGES [ FOR { ROLE | USER } target_role [, ...] ]
This use case is why the "FOR target_role" clause exists.
