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.