| From: | Nicolas Paris <nicolas(dot)paris(at)riseup(dot)net> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Default Privilege Table ANY ROLE |
| Date: | 2018-11-15 21:45:00 |
| Message-ID: | 20181115214222.3wf4nrub4hhssixk@riseup.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Nov 14, 2018 at 03:19:00PM +0100, Nicolas Paris wrote:
> Hi
>
> I d'like my user be able to select on any new table from other users.
>
> > ALTER DEFAULT PRIVILEGES FOR ROLE "theowner1" IN SCHEMA "myschema" GRANT select ON TABLES TO "myuser"
> > ALTER DEFAULT PRIVILEGES FOR ROLE "theowner2" IN SCHEMA "myschema" GRANT select ON TABLES TO "myuser"
> > ...
>
>
> Do I really have to repeat the command for all users ?
>
> The problem is I have many user able to create tables and all of them
> have to read each other.
>
There is apparently no trivial solution, could the Postgres DCL be
extended with this syntax in the future ?
> ALTER DEFAULT PRIVILEGES FOR ALL ROLE IN SCHEMA "myschema" GRANT select ON TABLES TO "myuser"
--
nicolas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Munro | 2018-11-15 22:05:43 | Re: Impact on PostgreSQL due to Redhat acquisition by IBM |
| Previous Message | Paul Judson | 2018-11-15 21:31:10 | BDR and PostgreSQL 12 and Windows support |