Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kqIUg-0003jq-Fg for pgsql-admin@arkaria.postgresql.org; Fri, 18 Dec 2020 16:20:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kqIUf-0004aI-Ey for pgsql-admin@arkaria.postgresql.org; Fri, 18 Dec 2020 16:20:37 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kqIUf-0004aB-6q for pgsql-admin@lists.postgresql.org; Fri, 18 Dec 2020 16:20:37 +0000 Received: from tamriel.snowman.net ([70.109.60.50]) by makus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kqIUZ-00083G-3S for pgsql-admin@lists.postgresql.org; Fri, 18 Dec 2020 16:20:36 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id D16DC5F7A2; Fri, 18 Dec 2020 11:20:30 -0500 (EST) Date: Fri, 18 Dec 2020 11:20:30 -0500 From: Stephen Frost To: Ron Watkins Cc: pgsql-admin@lists.postgresql.org Subject: Re: Grant request Message-ID: <20201218162030.GD16415@tamriel.snowman.net> References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="IA012FEfzPn3AwW1" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --IA012FEfzPn3AwW1 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Greetings, * Ron Watkins (rwatki@gmail.com) wrote: > I have a Azure production server, and a group of users is requesting select > permissions for all tables, views, sequences, etc. > This is for all existing and all new objects in all schemas in the database. > I don't see any kind of "db_datareader" role. Suggestions? https://commitfest.postgresql.org/31/2702/ Hopefully will be included in PG14. Would be great to have folks who have this requirement take a look at and play with that patch and make sure that the role meets your requirements. Thanks, Stephen --IA012FEfzPn3AwW1 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJf3NbOAAoJEO1sijiDR2RVqqQP/24oE0ei2y76ZQuU6jx9PsXn Tqaa688s9mxa7xbNHMIcDu5cezM74jEGMwcoK+gx0GWDCjtlpHuJdJjRUMhrxBjY +gm9CFqOPhN/qBCoqC1ndz/cqvZOJ7rBcXOATnfSjd+MvVjnpy8aH/isDWJEDfeV o9yBKpZeuYxORamtCjaG3k+5iKzAGEDEFZm6rwlcb+pDECohFcHSJ15QwLD4jc+b JxkW9aVUNjw3xJCGp1YSaSrYurCnWn13z5Ih+RfBsXds/sI/gBavoGw4wj2Hj7hm 8G0lkjMaeSGn+KHkPOKdqLxt66wK04YZhDpZo6AbDNHWcsmsrxqkURkhSksgLqG4 8GkyDsnG49ZsjipUhxdXCSVAXU4zjtDEa592JaOk5WD7c+H56gId7WMwrO/3wKqr QYPP1x9mgoN5uW9Xcm+Jj63n9Dd9l+I2KihLTmCWieQrJ3cgFhC+lMG7oAtBJ+4Q J3pibN+dWEMUC1171m3yf0/gspGhnvY2fciqfmNEY9m9+jgHgyVzEIvXFrm2PbZd 01Iri2Z4QbXgk5pRJ4py7K/E7lGZ93hA4zpQOI66nFdcjGFXn7l2+Hk+Y6I/1P8B tTOL0mtA10P5wpWST1KktH+gJrQ1C3AiFaYW3IXo77FcSIy/7tkKQCGJKyd0gZXc 4dPmz/TMEsQulvFZ8t5X =W/Hw -----END PGP SIGNATURE----- --IA012FEfzPn3AwW1--