Another permission-related issue involves scenarios where multiple logical
replication slots exist. If a replication slot grants full data access
permissions and user accounts are not explicitly bound to specific slots, there
could be security risks where accounts might connect to high-privilege
Amit Kapila, Yes, as you mentioned, but I’d like to add that when using the
exclusion method for newly added columns, there’s no need to modify the
publication. This is similar to how fields are automatically synchronized when
columns are unspecified during initial setup. This is also a key reas
On Fri, Apr 11, 2025 at 3:40 AM Peter Smith wrote:
>
> FYI, the Column List documentation [1] says
> --
> However, do not rely on this feature for security: a malicious
> subscriber is able to obtain data from columns that are not
> specifically published. If security is a consideration, prote
Hi,
FYI, the Column List documentation [1] says
--
However, do not rely on this feature for security: a malicious
subscriber is able to obtain data from columns that are not
specifically published. If security is a consideration, protections
can be applied at the publisher side.
--
IIRC,
On Thu, Apr 10, 2025 at 10:12 AM YeXiu <1518981...@qq.com> wrote:
>
> For example:
> Assume database db1 has a user table with columns c1, c2, c3, ..., c10,
> telphone, and content (where telphone is a sensitive data field, and
> content is of type text).
>
> 1.We need to synchronize the user tabl
For example:
Assume database db1 has a user table with columns c1, c2, c3, ..., c10,
telphone, and content (where telphone is a sensitive data field, and content is
of type text).
1.We need to synchronize the user table to the BI department, but they should
not have access to the telphone colu
On Tue, Apr 8, 2025 at 2:48 PM YeXiu <1518981...@qq.com> wrote:
>
> Business Scenario:
> The BI department requires real-time data from the operational database. In
> our current approach (on platform 14), we create a separate database within
> our department's real-time backup instance, set up a
Business Scenario:
The BI department requires real-time data from the operational database. In our
current approach (on platform 14), we create a separate database within our
department's real-time backup instance, set up a logical replication account,
replicate required tables to this isolated
