create user backup;

GRANT USAGE ON SCHEMA pg_catalog TO backup;
GRANT EXECUTE ON FUNCTION pg_stop_backup() TO backup;
GRANT EXECUTE ON FUNCTION pg_stop_backup(boolean) TO backup;

grant all on table pg_subscription to backup;
grant all (subenabled) on pg_subscription to backup;
grant all (subconninfo) on pg_subscription to backup;
grant all on pg_stat_subscription to backup;
grant all (received_lsn) on pg_stat_subscription to backup;
grant all (latest_end_lsn) on pg_stat_subscription to backup;
grant all on function pg_stat_get_subscription to backup;
grant all on language sql to backup;