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

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: "pgsql-sql(at)postgresql(dot)org" <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 03:36:13
Message-ID: 20181215033612.xc5vjh2crbemf42y@ler-imac-2.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Fri, Dec 14, 2018 at 08:26:42PM -0700, David G. Johnston wrote:
> On Friday, December 14, 2018, Larry Rosenman <ler(at)lerctr(dot)org> wrote:
> >
> > Is this a bug or do I/should I re-issue the GRANT when we add tables?
> >
>
> See: https://www.postgresql.org/docs/11/sql-alterdefaultprivileges.html
>
Thank You, Sir! Exactly what I was looking for.

> David J.

--
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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message 梁博 2018-12-28 10:31:51 backend process was crashed when using zabbix monitor
Previous Message David G. Johnston 2018-12-15 03:26:42 Re: GRANT SELECT ON ALL TABLES IN SCHEMA... doesn't apply to new tables?