search

resolve-works / insight

Insight turns data into information, by putting it into context.
GNU Affero General Public License v3.0
0 stars 0 forks source link

Debezium SQL permissions #117

Open monneyboi opened 3 hours ago

monneyboi commented 3 hours ago

Right now debezium creates a publication for all tables. Change this behaviour to only the tables we need. https://debezium.io/documentation/reference/stable/connectors/postgresql.html#postgresql-publication-autocreate-mode

monneyboi commented 2 hours ago 
CREATE PUBLICATION dbz_publication FOR TABLE private.inodes;
GRANT SELECT ON TABLE private.inodes to debezium;