create user 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;