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
