Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qzOGW-00FyKU-6W for pgsql-general@arkaria.postgresql.org; Sat, 04 Nov 2023 21:33:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qzOGU-007Ui6-4o for pgsql-general@arkaria.postgresql.org; Sat, 04 Nov 2023 21:33:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qzOGT-007Uhy-QC for pgsql-general@lists.postgresql.org; Sat, 04 Nov 2023 21:33:09 +0000 Received: from mail.hjp.at ([212.17.106.138] helo=rorschach.hjp.at) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qzOGP-004iuf-5D for pgsql-general@lists.postgresql.org; Sat, 04 Nov 2023 21:33:08 +0000 Received: by rorschach.hjp.at (Postfix, from userid 1000) id 9AE2517D3D; Sat, 4 Nov 2023 22:33:03 +0100 (CET) Date: Sat, 4 Nov 2023 22:33:03 +0100 From: "Peter J. Holzer" To: pgsql-general@lists.postgresql.org Subject: Re: Postgres limitation in user management Message-ID: <20231104213303.4mtgamfyo4v5i33e@hjp.at> Mail-Followup-To: pgsql-general@lists.postgresql.org References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="duhtbt35a23dnt66" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --duhtbt35a23dnt66 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On 2023-11-03 06:26:21 +0000, Kar, Swapnil (TR Technology) wrote: > We have 2 sets of database user groups =E2=80=93 >=20 > 1. App =E2=80=93 who owns the application schemas (and tables) > 2. Support =E2=80=93 who provides db support >=20 > We want Support users to have no SELECT or DML privilege but only ALTER T= ABLE > to perform any troubleshooting in the database. This seems strange to me. What kind of troubleshooting requires to ability to ALTER TABLE but not to do DML? hp --=20 _ | Peter J. Holzer | Story must make more sense than reality. |_|_) | | | | | hjp@hjp.at | -- Charles Stross, "Creative writing __/ | http://www.hjp.at/ | challenge!" --duhtbt35a23dnt66 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEETtJbRjyPwVTYGJ5k8g5IURL+KF0FAmVGuIoACgkQ8g5IURL+ KF02KA/+PSqRZCsCL7+UJ8WgYUNN5CJU7rhOi/eLQXpxy0h5d/PDrcRD8WdAlMnP jSJZUc6/LX+ICC9ZAo28k/CHc0+YDwskoQG84Kzvn7W6Dm8ZhcP6+qkL9bZAH7GR ao3tClHWTzNb2A3dcK87Z03A2SYP4f7H8fMTTLciEwFoGoDfZpkP4ZVEKVWLbQAe pkg/c4CplH54FUHe5QACOWU7mjotd7hL2/7lQFOtXXvZZnhkd86+oYJJV8kxhlTz oQfdbhfdqwKPlj9CUQTYzFl0k+wWUAZlOExOmXiTpK9X2ugXsvk7O5nMxTBb5sIg PZfkgYYOzdGaKwvBFwITMigmaLx/sLFuGWKj5zH0qDcNQivBZ5GGecz1Tc8fFDRx wm9gWcS2W8a409I9SUroxLqeh5NPq4LAjFkETUN0X31Zmfa1S+MmYgVMzQ9EplYL rJcEQTP/fxM4cl3HQeFHAOBShRJ5L1z5LLQZuOLJjfhQicV9XK2pZcJWDlAnKFyd K/GQ8i8gQahxOTz5A+wxrfQiem9kza7RSQ827StRxFLUb+dxIqYxGg2n8RoxqQm5 fWT7685RHLOq2G3Pc1ZZpLqbK0O94cof8va3cQLmTKhavIPiLUNMZC+NUyMF6OLC BFk7n0cr7LD4qPae+pubIwYhAHcOFZI/NNCONRr6v3tIdI1Umg8= =lBM/ -----END PGP SIGNATURE----- --duhtbt35a23dnt66--