8000 Revoke all from public on c functions by AndersAstrand · Pull Request #318 · percona/postgres · GitHub
[go: up one dir, main page]

Skip to content

Revoke all from publi 8000 c on c functions #318

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
wants to merge 1 commit into
base: TDE_REL_17_STABLE
Choose a base branch
from

Conversation

AndersAstrand
Copy link
Collaborator
@AndersAstrand AndersAstrand commented May 8, 2025

It feels better to have a white list of publicly executable functions than a black list.

I wasn't sure where tests that asserts that CREATE EXTENSION does the right thing belongs, but it felt like basic usage to me so I put the assertion that this is done there.

We don't have any security definer functions, but if we did they would also need to be revoked from public by default.

@codecov-commenter
Copy link
codecov-commenter commented May 8, 2025

Codecov Report

All modified and coverable lines are covered by tests ✅

Project coverage is 80.33%. Comparing base (784e45d) to head (eaa8f25).
Report is 1 commits behind head on TDE_REL_17_STABLE.

❌ Your project status has failed because the head coverage (80.33%) is below the target coverage (90.00%). You can increase the head coverage or adjust the target coverage.

Additional details and impacted files
@@                  Coverage Diff                  @@
##           TDE_REL_17_STABLE     #318      +/-   ##
=====================================================
+ Coverage              80.29%   80.33%   +0.03%     
=====================================================
  Files                     22       22              
  Lines                   2578     2578              
  Branches                 396      396              
=====================================================
+ Hits                    2070     2071       +1     
+ Misses                   428      427       -1     
  Partials                  80       80              
Components Coverage Δ
access 82.77% <ø> (ø)
catalog 87.47% <ø> (ø)
common 91.80% <ø> (ø)
encryption 76.63% <ø> (+0.93%) ⬆️
keyring 71.83% <ø> (ø)
src 66.74% <ø> (ø)
smgr 97.00% <ø> (ø)
transam ∅ <ø> (∅)
🚀 New features to boost your workflow:
  • ❄️ Test Analytics: Detect flaky tests, report on failures, and find test suite problems.

Even though we do have some access control in most of our C functions,
it seems dangerous to not revoke them from public by default. A
whitelist of allowed functions seems safer than a black list.
@AndersAstrand AndersAstrand force-pushed the tde/revoke-from-public branch from fecffc9 to eaa8f25 Compare May 8, 2025 09:38
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

2 participants
0