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

[PACE-12] Add optional extra Postgres grant that allows any other user with view access #25

Open
trietsch opened this issue Nov 7, 2023 · 2 comments
Labels
linear Created by Linear-GitHub Sync

Comments

@trietsch
Copy link
Contributor

trietsch commented Nov 7, 2023

The view that is created by PACE, isn't automatically accessible by any user that has access to the postgres cluster (this may apply to other processing platforms as well). Add an optional flag (api change) that allows for configuring arbitrary access to the view.

PACE-12

@ivan-p92
Copy link
Contributor

ivan-p92 commented Nov 7, 2023

This applies to all platforms. The question is to what extent this is the responsibility of PACE. I can imagine users prefer to do these grants from their provisioning layer. Read/select grants are often granted on parent schemas and can also be inherited from DB-level or similar.

@trietsch
Copy link
Contributor Author

trietsch commented Nov 7, 2023

Agreed with your comments. I've ran into this while creating the standalone example, and therefore I created this issue to make sure we discuss it.

@getstrmbot getstrmbot added the linear Created by Linear-GitHub Sync label Nov 7, 2023
@getstrmbot getstrmbot changed the title Add optional extra Postgres grant that allows any other user with view access [PACE-12] Add optional extra Postgres grant that allows any other user with view access Nov 7, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
linear Created by Linear-GitHub Sync
Projects
None yet
Development

No branches or pull requests

3 participants