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 1gXzT3-0005te-QP for pgsql-sql@arkaria.postgresql.org; Sat, 15 Dec 2018 02:14:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gXzT2-0004jT-4m for pgsql-sql@arkaria.postgresql.org; Sat, 15 Dec 2018 02:14:12 +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 1gXzT1-0004jI-FB for pgsql-sql@lists.postgresql.org; Sat, 15 Dec 2018 02:14:11 +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 1gXzSw-0001pn-L7 for pgsql-sql@postgresql.org; Sat, 15 Dec 2018 02:14:11 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=lerctr.org; s=lerami; h=Content-Type:MIME-Version:Message-ID:Subject:To:From:Date:Sender :Reply-To:Cc:Content-Transfer-Encoding:Content-ID:Content-Description: Resent-Date:Resent-From:Resent-Sender:Resent-To:Resent-Cc:Resent-Message-ID: In-Reply-To:References:List-Id:List-Help:List-Unsubscribe:List-Subscribe: List-Post:List-Owner:List-Archive; bh=1cJrvAcso78CaNjpHQR4sZUEBXLzwYJtDiolzmd1XUc=; b=sVlRE/TNvUbLNZV4loHu1wiZuK bSTRDGKDXL3NCAi88RhzRSPHOE0YkH0vPsv2Gj7uInpxjzPo8J+OZ55TMhSN9SQhSFUnK+RGAT/ys BljDAsXv7cs3i+b7nVaMrz65GNbinDCfp0zT+HJCKB47j4vZeounMWMRJuWFdIIPfZJw=; Received: from [2600:1700:210:b18f:316e:7968:bc70:d445] (port=57606 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 1gXzSq-000Ogf-5R for pgsql-sql@postgresql.org; Fri, 14 Dec 2018 20:14:00 -0600 Date: Fri, 14 Dec 2018 20:13:59 -0600 From: Larry Rosenman To: pgsql-sql@postgresql.org Subject: GRANT SELECT ON ALL TABLES IN SCHEMA... doesn't apply to new tables? Message-ID: <20181215021359.m4horbexxiai4xez@ler-imac-2.local> Mail-Followup-To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="5jso2ub2bf3cnzba" Content-Disposition: inline User-Agent: NeoMutt/20180716 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --5jso2ub2bf3cnzba Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable 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. =20 Is this a bug or do I/should I re-issue the GRANT when we add tables? --=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 --5jso2ub2bf3cnzba Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQHABAABCgCqFiEEHjgknedhWzvJgwVzaXyZsatIp30FAlwUY2csFIAAAAAAFQAO cGthLWFkZHJlc3NAZ251cGcub3JnbGVyQGxlcmN0ci5vcmdfFIAAAAAALgAoaXNz dWVyLWZwckBub3RhdGlvbnMub3BlbnBncC5maWZ0aGhvcnNlbWFuLm5ldDFFMzgy NDlERTc2MTVCM0JDOTgzMDU3MzY5N0M5OUIxQUI0OEE3N0QACgkQaXyZsatIp32e gwgAjU3Uwc0rJRP92swGwcSgcpQWZcf0gErw6jonECzhtS+opF5Gsh3U6h4rpCUC vJuTJntPCg9GMmjOaqXv90xlcZMoYOds/3jwqgSRMS8K16zPxUImTfPd2LU/kAq/ 34v7MNlAoG+TG41GY32tq9e/WtmDwbmw+g7u6zYHA74w89z03Dl9flxXOJI1VhgS pHYReBp7JpooQ7SR88wqqlSybM3dBheN15U6ObNL/KGQjRwg21bn43FL1aYq7vnV PsclKLuLpgw2Zw8RZk5ar6TT9fVxJ6JJJIeD+ld8xUNC+poTsdJsK3qJbeD7cXUh iDsNiqBWos+5zF5xvIS/3hI+rA== =kfoA -----END PGP SIGNATURE----- --5jso2ub2bf3cnzba--