I am using PostgreSQL 9.4, I want to make a user with permanent read only access on public schema. I have tried many different ways to get this but using
REVOKE ALL on schema public to user1; GRANT SELECT on all tables in schema PUBLIC to user1;
doesn't make any sense for me, user
user1 is not able to change any table but is still able to create new tables in public schema.