| From: | Rob Sargent <robjsargent(at)gmail(dot)com> |
|---|---|
| To: | Larry Rosenman <ler(at)lerctr(dot)org> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: GRANT SELECT ON ALL TABLES IN SCHEMA... doesn't apply to new tables? |
| Date: | 2018-12-15 02:50:09 |
| Message-ID: | C09C82B5-2527-4EDA-B23B-BDB268576C0C@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Reissue. I think your grant is really a wrapper that grants to each existing table
> On Dec 14, 2018, at 7:13 PM, 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.
>
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2018-12-15 03:26:42 | Re: GRANT SELECT ON ALL TABLES IN SCHEMA... doesn't apply to new tables? |
| Previous Message | Christopher Swingley | 2018-12-15 02:21:40 | Re: GRANT SELECT ON ALL TABLES IN SCHEMA... doesn't apply to new tables? |