Re: Default Privilege Table ANY ROLE - Mailing list pgsql-general

From Nicolas Paris
Subject Re: Default Privilege Table ANY ROLE
Date
Msg-id 20181115214222.3wf4nrub4hhssixk@riseup.net
Whole thread Raw
In response to Default Privilege Table ANY ROLE  (Nicolas Paris <nicolas.paris@riseup.net>)
List 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


pgsql-general by date:

Previous
From: Paul Judson
Date:
Subject: BDR and PostgreSQL 12 and Windows support
Next
From: Thomas Munro
Date:
Subject: Re: Impact on PostgreSQL due to Redhat acquisition by IBM