Postgres user with access only on replica

0

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?

    
asked by anonymous 13.08.2018 / 23:14

1 answer

0

The solution we found was to limit ip access in pg_hba.conf.

    
19.08.2018 / 16:31