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.
