Replace superuser check by ACLs for replication origin functions
authorMichael Paquier <[email protected]>
Sun, 14 Jun 2020 03:40:37 +0000 (12:40 +0900)
committerMichael Paquier <[email protected]>
Sun, 14 Jun 2020 03:40:37 +0000 (12:40 +0900)
commitcc072641d41c55c6aa24a331fc1f8029e0a8d799
treeb2e41e350248c66fc5528a380150795ccc13f349
parent23cbeda50b94c817bed4f7d2127ee09c4e8c8b86
Replace superuser check by ACLs for replication origin functions

This patch removes the hardcoded check for superuser privileges when
executing replication origin functions.  Instead, execution is revoked
from public, meaning that those functions can be executed by a superuser
and that access to them can be granted.

Author: Martín Marqués
Reviewed-by: Kyotaro Horiguchi, Michael Paquier, Masahiko Sawada
Discussion: https:/postgr.es/m/CAPdiE1xJMZOKQL3dgHMUrPqysZkgwzSMXETfKkHYnBAB7-0VRQ@mail.gmail.com
contrib/test_decoding/expected/replorigin.out
contrib/test_decoding/sql/replorigin.sql
doc/src/sgml/func.sgml
src/backend/catalog/system_views.sql
src/backend/replication/logical/origin.c