pace icon indicating copy to clipboard operation
pace copied to clipboard

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

Open trietsch opened this issue 2 years ago • 2 comments

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

trietsch avatar Nov 07 '23 10:11 trietsch

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.

ivan-p92 avatar Nov 07 '23 10:11 ivan-p92

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.

trietsch avatar Nov 07 '23 11:11 trietsch