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

Support ALTER DEFAULT PRIVILEGES #15136

Open
StrikeW opened this issue Feb 19, 2024 · 1 comment
Open

Support ALTER DEFAULT PRIVILEGES #15136

StrikeW opened this issue Feb 19, 2024 · 1 comment
Assignees

Comments

@StrikeW
Copy link
Contributor

StrikeW commented Feb 19, 2024

Is your feature request related to a problem? Please describe.

Motivation: GRANT SELECT ON ALL TABLES IN SCHEMA public TO myuser only applies to existing tables not tables created in future.

ALTER DEFAULT PRIVILEGES can apply to future created tables. e.g.:
Grant SELECT privilege to everyone for all tables (and views) you subsequently create in schema myschema

ALTER DEFAULT PRIVILEGES IN SCHEMA myschema GRANT SELECT ON TABLES TO PUBLIC;

requested by a user.

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

https://www.postgresql.org/docs/current/sql-alterdefaultprivileges.html

@github-actions github-actions bot added this to the release-1.7 milestone Feb 19, 2024
@StrikeW
Copy link
Contributor Author

StrikeW commented Feb 21, 2024

cc @yezizp2012

@fuyufjh fuyufjh modified the milestones: release-1.8, release-1.9 Apr 8, 2024
@yezizp2012 yezizp2012 modified the milestones: release-1.9, release-1.10 May 14, 2024
@yezizp2012 yezizp2012 removed this from the release-1.10 milestone Jul 5, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants