On 11/14/2018 08:19 AM, 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.

Would ROLE Groups solve your problem?


--
Angular momentum makes the world go 'round.

Reply via email to