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 1gY0ka-0001ZA-4d for pgsql-sql@arkaria.postgresql.org; Sat, 15 Dec 2018 03:36:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gY0kY-0006jg-Gz for pgsql-sql@arkaria.postgresql.org; Sat, 15 Dec 2018 03:36:22 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gY0kX-0006gR-0u for pgsql-sql@lists.postgresql.org; Sat, 15 Dec 2018 03:36:22 +0000 Received: from thebighonker.lerctr.org ([2001:470:1f0f:3ad:bb:dcff:fe50:d900]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gY0kT-0004Fw-1L for pgsql-sql@postgresql.org; Sat, 15 Dec 2018 03:36:20 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=lerctr.org; s=lerami; h=In-Reply-To:Content-Type:MIME-Version:References:Message-ID: Subject:Cc:To:From:Date:Sender:Reply-To:Content-Transfer-Encoding:Content-ID: Content-Description:Resent-Date:Resent-From:Resent-Sender:Resent-To:Resent-Cc :Resent-Message-ID:List-Id:List-Help:List-Unsubscribe:List-Subscribe: List-Post:List-Owner:List-Archive; bh=b9bUFj6hJKBPlhkJei7n8DPJ6pIwYFMeKFqw5k6FtWc=; b=Tnb14waq469WLMkRngRFIEtQHN 8kaGjPM5rzvjX3hd9aCu+kv+K1uofZmRR+5Tz+QzAfmmqSqlLpfumzkzA5Y9sZclnxyI5fSels2ja FWYaPzw78S9wgkyxWg0vLdmb8sXQUg5GuJxcHfZQmEUBpOQqfEKb68hGhAergONQZT0A=; Received: from [2600:1700:210:b18f:316e:7968:bc70:d445] (port=58940 helo=ler-imac-2.local) by thebighonker.lerctr.org with esmtpsa (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256) (Exim 4.91 (FreeBSD)) (envelope-from ) id 1gY0kP-0000cu-PI; Fri, 14 Dec 2018 21:36:13 -0600 Date: Fri, 14 Dec 2018 21:36:13 -0600 From: Larry Rosenman To: "David G. Johnston" Cc: "pgsql-sql@postgresql.org" Subject: Re: GRANT SELECT ON ALL TABLES IN SCHEMA... doesn't apply to new tables? Message-ID: <20181215033612.xc5vjh2crbemf42y@ler-imac-2.local> Mail-Followup-To: "David G. Johnston" , "pgsql-sql@postgresql.org" References: <20181215021359.m4horbexxiai4xez@ler-imac-2.local> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="2jlqgalc6gqeevwk" Content-Disposition: inline In-Reply-To: User-Agent: NeoMutt/20180716 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --2jlqgalc6gqeevwk Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Dec 14, 2018 at 08:26:42PM -0700, David G. Johnston wrote: > On Friday, December 14, 2018, Larry Rosenman wrote: > > > > Is this a bug or do I/should I re-issue the GRANT when we add tables? > > >=20 > See: https://www.postgresql.org/docs/11/sql-alterdefaultprivileges.html >=20 Thank You, Sir! Exactly what I was looking for. > David J. --=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 --2jlqgalc6gqeevwk Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQHABAABCgCqFiEEHjgknedhWzvJgwVzaXyZsatIp30FAlwUdqwsFIAAAAAAFQAO cGthLWFkZHJlc3NAZ251cGcub3JnbGVyQGxlcmN0ci5vcmdfFIAAAAAALgAoaXNz dWVyLWZwckBub3RhdGlvbnMub3BlbnBncC5maWZ0aGhvcnNlbWFuLm5ldDFFMzgy NDlERTc2MTVCM0JDOTgzMDU3MzY5N0M5OUIxQUI0OEE3N0QACgkQaXyZsatIp32M IQgAkmla3OUpP9rc2GD+rmPRVTNBSZKIHvXj8K2u955FOIg87TX1ZbZ9ghKW0Obh e+zJQY4WlJvqypykM04Q9CwO/oYuOTgt0Qoas/c0efwCNpjzOG0CkxcXyyB6zLbF eNUke6zjNj+DMtpxRa4Ms+HL/aOCshc9/J8JJcnYIrXIcpaGUHIcUZF8pib3QFb+ EEEfJnYR2uIo/Bx0Va/Nt8hu5HH5Pr5xjj/cKoDO3w4eyQS4abJWBcD0Uvxpeleg utlgGbPnof/fkyvNpPpufninnnTm7vlzv6eUfnC8m85+Z8EIYhxoETGvBDpQWVSm WukAFgNHbnzzTDuinl9cemgbrA== =kbQM -----END PGP SIGNATURE----- --2jlqgalc6gqeevwk--