Postgres user with access only in the replica

Asked

Viewed 56 times

0

The database in question has replication of data, the same database, however on another server, has to ensure the access of a user ( user_bi ) only in the replica ?

REVOKE ALL ON ALL TABLES IN SCHEMA public FROM user_bi;

This revokes the bank’s permissions, but also revokes the replicate permissions, and allows access to one and not to another ?

postgresql permissions replication

1 answer

0


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

Browser other questions tagged postgresql permissions replication

You are not signed in. Login or sign up in order to post.