Default Privilege Table ANY ROLE

From: Nicolas Paris <nicolas(dot)paris(at)riseup(dot)net>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Default Privilege Table ANY ROLE
Date: 2018-11-14 14:19:00
Message-ID: 20181114141608.ryvolxl7v7z2grzi@riseup.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Thanks

--
nicolas

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2018-11-14 14:58:33 Re: Move cluster to new host, upgraded version
Previous Message Adrian Klaver 2018-11-14 13:38:03 Re: Impact on PostgreSQL due to Redhat acquisition by IBM