citusdata / citusdata/citus

ALTER DEFAULT PRIVILEGES does not work for schemas and views

Open
#6,620 1 comment 0 reactions 0 assignees View on GitHub
bug dev_reported sql
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

After changing to #5442 to use `ALTER DEFAULT PRIVILEGES` I found out that not all GRANTs created by `ALTER DEFAULT PRIVELEGES` are propagated to workers. Specifically grants on VIEWs and grants on SCHEMAs are not.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.