The database in question has data replication, the same database, but on another server, can you guarantee a user (user_bi) access to the replica only?
REVOKE ALL ON ALL TABLES IN SCHEMA public FROM user_bi;
This revokes the permissions of the bank, but also revokes the permissions of the replica, is it allowed to access one and not another?