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

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: GRANT SELECT ON ALL TABLES IN SCHEMA... doesn't apply to new tables?
Date: 2018-12-15 02:13:59
Message-ID: 20181215021359.m4horbexxiai4xez@ler-imac-2.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Is this a bug or do I/should I re-issue the GRANT when we add tables?

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: ler(at)lerctr(dot)org
US Mail: 5708 Sabbia Drive, Round Rock, TX 78665-2106

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Christopher Swingley 2018-12-15 02:21:40 Re: GRANT SELECT ON ALL TABLES IN SCHEMA... doesn't apply to new tables?
Previous Message Shekar Tippur 2018-12-13 16:51:59 Changing csv structure and corresponding etl