Hi, Probably you need to grant permission like this
GRANT SELECT ON ALL TABLES IN SCHEMA public TO user1;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO user2;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO user3;
And just each owner can insert or update
______________________
Saludos Ing. Ricardo Martín Gomez
DBA - SysAdmin
De: Steven Crandell <steven.crandell@gmail.com>
Enviado: miércoles, 14 de marzo de 2018 01:23 a.m.
Para: Richard Gbs
Cc: pgsql-admin@lists.postgresql.org
Asunto: Re: Permission issues. Please help