From: | Olivier Macchioni <olivier(dot)macchioni(at)wingo(dot)ch> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Granting a user the privilege to create views? |
Date: | 2018-08-28 08:48:32 |
Message-ID: | 676E40C7-0578-440F-9D9E-4AD055D70646@wingo.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello dear list,
Context:
PostgreSQL instance, version 10.1 used for Datawarehousing.
We have an ETL system loading lots of data on this instance, with all kind of business metrics. For most of the data, we're using a snowflake schema (https://en.wikipedia.org/wiki/Snowflake_schema <https://en.wikipedia.org/wiki/Snowflake_schema>)
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 <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
From | Date | Subject | |
---|---|---|---|
Next Message | Csaba Ragasits | 2018-08-28 08:58:52 | Re: pg_basebackup + SSL error: bad length |
Previous Message | pavan95 | 2018-08-28 08:47:05 | Re: Which background task looks for pg_xlog in 10? |