Skip to content
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

Exclude predefined roles from diffs #7

Open
fpuga opened this issue Nov 5, 2024 · 1 comment
Open

Exclude predefined roles from diffs #7

fpuga opened this issue Nov 5, 2024 · 1 comment
Labels
enhancement New feature or request good first issue Good for newcomers

Comments

@fpuga
Copy link

fpuga commented Nov 5, 2024

I'm testing this extension as it can be really helpful to review privileges.

When using the diffs function i'm using it like this:

SELECT * from public.permission_diffs() WHERE role_name NOT LIKE 'pg_%';

to avoid pg_write_all_data, ... to appear in the output.

Have your consider excluding predefined roles by default?

Or maybe provide a set of INSERT INTO public.permission_target example queries that set the permissions for the predefined roles.

@laurenz laurenz added enhancement New feature or request good first issue Good for newcomers labels Nov 5, 2024
@laurenz
Copy link
Contributor

laurenz commented Nov 5, 2024

That would be a useful enhancement; we should ignore the predefined roles.
I'll leave it open as an enhancement request.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request good first issue Good for newcomers
Projects
None yet
Development

No branches or pull requests

2 participants