Re: GRANT SELECT ON ALL TABLES IN SCHEMA... doesn't apply to new tables?

Larry,

On Fri, Dec 14, 2018 at 17:14 Larry Rosenman <ler(at)lerctr(dot)org> wrote:

> I have the following grant in effect:
> GRANT SELECT ON ALL TABLES IN SCHEMA public TO readonly;
>
> We occasionally add tables to that schema, but the readonly role
> can't read them.

What you want is to apply default privileges to the roles that will be
creating new objects:

https://www.postgresql.org/docs/current/sql-alterdefaultprivileges.html

Your existing GRANT will take care of the tables you have, default
privileges will set permissions on new tables. \ddp shows the in psql.

Cheers,

Chris

--
Christopher Swingley
Fairbanks, Alaska
http://swingleydev.com/
cswingle(at)swingleydev(dot)com