Access to pg_replication_origin* functions - Mailing list pgsql-general

From Egor Voynov
Subject Access to pg_replication_origin* functions
Date
Msg-id CANc5o7aqz7S=7msdLD=WS4MMWC-jEM76QQy6gU7xU39uJ2==rg@mail.gmail.com
Whole thread Raw
List pgsql-general

Hi all,

I have a question regarding access to replication origin functions, such as  pg_catalog.pg_replication_origin* (e.g. pg_replication_origin_oid(text)).

At the moment, access to these functions has to be granted individually. Should users with the REPLICATION attribute be allowed to execute them by default?

Alternatively, would it make sense to grant this access in bulk via an existing role like pg_create_subscription, or perhaps introduce a dedicated predefined role for this purpose?

These functions are closely related to replication, but it’s not entirely clear what the intended privilege model is here.

Any thoughts?

Best regards,

Egor Voynov

pgsql-general by date:

Previous
From: Durgamahesh Manne
Date:
Subject: Re: Fillfactor effectiveness on existing table
Next
From: Wim Rouquart
Date:
Subject: RE: Index (primary key) corrupt?