Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gY01x-0007Wk-2B for pgsql-sql@arkaria.postgresql.org; Sat, 15 Dec 2018 02:50:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gY01v-0003aU-P6 for pgsql-sql@arkaria.postgresql.org; Sat, 15 Dec 2018 02:50:15 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gY01v-0003Th-DI for pgsql-sql@lists.postgresql.org; Sat, 15 Dec 2018 02:50:15 +0000 Received: from mail-io1-xd2c.google.com ([2607:f8b0:4864:20::d2c]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gY01s-0004AT-Lz for pgsql-sql@postgresql.org; Sat, 15 Dec 2018 02:50:14 +0000 Received: by mail-io1-xd2c.google.com with SMTP id x6so5989745ioa.9 for ; Fri, 14 Dec 2018 18:50:12 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=Mt80ln2dyeRjt142IL0gShfgk5lTDeT7pMtqaOmodf4=; b=CO9E24blslUFohRWzJSOkZg60Q7Gi188VNjO1Ca4cMfpfUDsaNmPehFGR7v2yswORx YQ3Pu1iEDCRU0cCUeCLK4ieOO8wnsJ3fRatq7B11PyRInq7S3wvhYP/PIFSYezJKjDoq CwyzgeIp51SEt5PYFi2WDsKJG3UMXtLy19eOC4dhlMSmegAPUauwYNcwFGVCDF5euc17 tC4MGb5O38pnNGHunUYxkTV1Rfw9yO3M+c135bpEu/5E4I+RF3nkAw4pti635q8lJHY3 6kz36VtTlqy1kcfygp8Ajiu9A/oONpHwDvhERThm6a7C7EGjhYa0g1j/6mQcm0+KG7Eb zoxQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=Mt80ln2dyeRjt142IL0gShfgk5lTDeT7pMtqaOmodf4=; b=pfa2SO0NTg1OsvTPcAsxkbXGh5BZiJjFJ94ZUnHWe2wCJvr2nkD+/OM9HK/RRrUggX iE/eZKuRr1V6LwtIBTbkiPs0JewiQq0cQgm/hzvi5jCkkXmYzs9qb41kKAyWRCV7/YfT tKlb+8v6TQHAQVX5mquBKkkE5ROQHpjIk3T4GLYWcxees0fUOucIe+lnHmjh1faVfGsW EEhTW5ltm+jTFrUTJZXye3I5vt12O4fVRpERl+avPoIOrApGlsqDisuHMG1K/koX7yYz SaIuepWH7zcXXvDHJykhffyZX/0HbZWFLg0Z2o55LN+omTQaVts1r5kLuzKzbgN22qi5 tVEA== X-Gm-Message-State: AA+aEWYqyyp++lI1dSm/h0O8aUQAQ5hpy1t4WhtwIGMfgcSdk1pZibU3 gK+VHJ3O9jEieftWkRuvEI4PdK/e X-Google-Smtp-Source: AFSGD/Uk5zRUpj7ghz6qBAMtom7Co0BlceKX772QFNUN10sq19bDKzWp/5Xm1C3dTYpnIQ8YDYTB1g== X-Received: by 2002:a6b:ab85:: with SMTP id u127mr4123169ioe.143.1544842211141; Fri, 14 Dec 2018 18:50:11 -0800 (PST) Received: from ?IPv6:2601:681:5500:1e3c:c59a:2c66:ba:4b4f? ([2601:681:5500:1e3c:c59a:2c66:ba:4b4f]) by smtp.gmail.com with ESMTPSA id c194sm4117184itc.3.2018.12.14.18.50.10 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Fri, 14 Dec 2018 18:50:10 -0800 (PST) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (1.0) Subject: Re: GRANT SELECT ON ALL TABLES IN SCHEMA... doesn't apply to new tables? From: Rob Sargent X-Mailer: iPhone Mail (16B92) In-Reply-To: <20181215021359.m4horbexxiai4xez@ler-imac-2.local> Date: Fri, 14 Dec 2018 19:50:09 -0700 Cc: pgsql-sql@postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: References: <20181215021359.m4horbexxiai4xez@ler-imac-2.local> To: Larry Rosenman List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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 wrote: >=20 > I have the following grant in effect: > GRANT SELECT ON ALL TABLES IN SCHEMA public TO readonly; >=20 > We occasionally add tables to that schema, but the readonly role > can't read them. =20 >=20 > Is this a bug or do I/should I re-issue the GRANT when we add tables? >=20 >=20 >=20 >=20 > --=20 > Larry Rosenman http://www.lerctr.org/~ler > Phone: +1 214-642-9640 E-Mail: ler@lerctr.org > US Mail: 5708 Sabbia Drive, Round Rock, TX 78665-2106