Postgres Pro
Downloads
Home   >   mailing lists

Default Privilege Table ANY ROLE - Mailing list pgsql-general

From Nicolas Paris
Subject Default Privilege Table ANY ROLE
Date
Msg-id 20181114141608.ryvolxl7v7z2grzi@riseup.net
Whole thread Raw
Responses Re: Default Privilege Table ANY ROLE
Re: Default Privilege Table ANY ROLE
Re: Default Privilege Table ANY ROLE
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Impact on PostgreSQL due to Redhat acquisition by IBM
Next
From: Rich Shepard
Date:
Subject: Re: Move cluster to new host, upgraded version