Nov 2021

1 commit
Fix GRANTED BY support in REVOKE ROLE statements
26 Nov 2021Daniel Gustafssonmaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1REL_14_STABLE14.2
LLM analysis, 100% suremodified before commitlight changesfrom patchset #161 of 1 reviewer saw the final version

The grammar changes, grantor validation, and privileges tests match #16; the commit only adds an explanatory comment and blank line in src/backend/commands/user.c.

  • Peter Eisentrautsaw the final versionLLM analysis, 83% surePeter confirmed that the missing REVOKE ROLE handling was an oversight in #17, following the corrected proposal in #16.

Jan 2021

1 commit
Allow GRANTED BY clause in normal GRANT and REVOKE statements
30 Jan 2021Peter Eisentrautmaster14beta1REL_19_STABLE14beta1REL_18_STABLE14beta1REL_17_STABLE14beta1REL_16_STABLE14beta1REL_15_STABLE14beta1REL_14_STABLE14beta1
LLM analysis, 100% suremodified before commitlight changesfrom patchset #121 of 1 reviewer saw the final version

The implementation and documentation match #12, with added privileges.sql and privileges.out coverage for CURRENT_USER, CURRENT_ROLE, and rejection of a different grantor, as requested in #13.

  • Simon Riggssaw the final versiontrailerSimon approved the implementation in #13 and requested regression tests, which were the only substantive additions before commit.

Sep 2020

2 commits
Try to stabilize output from rolenames regression test.
18 Sep 2020Tom Lanemaster14beta1REL_19_STABLE14beta1REL_18_STABLE14beta1REL_17_STABLE14beta1REL_16_STABLE14beta1REL_15_STABLE14beta1REL_14_STABLE14beta1
LLM analysis, 100% surewritten from the discussion, no matching patch

Tom Lane reported buildfarm instability in #11; this unattached follow-up extends ORDER BY keys and simplifies test function declarations in the rolenames SQL and expected output.

Allow CURRENT_ROLE where CURRENT_USER is accepted
17 Sep 2020Peter Eisentrautmaster14beta1REL_19_STABLE14beta1REL_18_STABLE14beta1REL_17_STABLE14beta1REL_16_STABLE14beta1REL_15_STABLE14beta1REL_14_STABLE14beta1
LLM analysis, 100% suremodified before commitlight changesfrom patchset #62 of 3 reviewers saw the final version

The commit matches #6 except for adding the quoted current_role role to DROP OWNED BY and DROP ROLE cleanup in rolenames.sql and its expected output, implementing #9.

  • Vik Fearingsaw an earlier versiontrailerVik approved the initial patch in #2, before #6 introduced a distinct role-specification enum and associated handling.
  • Asif Rehmansaw the final versiontrailerAsif reported successful testing and reviewed the grammar representation in #7, after which only test cleanup changed.
  • Alvaro Herrerasaw the final versiontrailerAlvaro identified missing documentation in #4, then approved the updated patch and requested role cleanup in #9.

Credits across 4 commits

Author
Peter EisentrautLLM2
Daniel GustafssonLLM1
Reviewer
Alvaro Herrera1
Asif Rehman1
Simon Riggs1
Vik Fearing1
Committer
Peter Eisentraut2
Daniel Gustafsson1
Tom Lane1

N LLM means N of the credits come from LLM analysis, not from commit trailers.