Hello dear list,
Context:
PostgreSQL instance, version 10.1 used for Datawarehousing.
Some users have read-only access to the DB and use various reporting tools to extract valuable information.
In order to do this, they do a lot of JOIN... all the time. They expressed the wish to be able to create VIEWS to simplify their SQL requests. Obviously I would like to allow them to do so. My understanding (based on reading the documentation and one some posts like
https://stackoverflow.com/questions/19811683/cannot-grant-create-view-on-schema) is that it's currently not possible to grant them only this additional privilege.
Is it still the case?... Do you know any practical workaround which I could use?
Thank you,
Olivier