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 1qzOh0-00G0nQ-SA for pgsql-general@arkaria.postgresql.org; Sat, 04 Nov 2023 22:00:34 +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 1qzOgz-007gPk-BW for pgsql-general@arkaria.postgresql.org; Sat, 04 Nov 2023 22:00:33 +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 1qzOgz-007gPb-0F for pgsql-general@lists.postgresql.org; Sat, 04 Nov 2023 22:00:33 +0000 Received: from smtp69.iad3b.emailsrvr.com ([146.20.161.69]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qzOgw-004j5j-QB for pgsql-general@lists.postgresql.org; Sat, 04 Nov 2023 22:00:32 +0000 X-Auth-ID: xof@thebuild.com Received: by smtp1.relay.iad3b.emailsrvr.com (Authenticated sender: xof-AT-thebuild.com) with ESMTPSA id 78DC560189; Sat, 4 Nov 2023 18:00:28 -0400 (EDT) Subject: Re: Postgres limitation in user management Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.7\)) Content-Type: text/plain; charset=us-ascii From: Christophe Pettus X-Priority: 1 In-Reply-To: Date: Sat, 4 Nov 2023 14:59:27 -0700 Cc: "pgsql-general@lists.postgresql.org" Content-Transfer-Encoding: quoted-printable Message-Id: References: To: "Kar, Swapnil (TR Technology)" X-Mailer: Apple Mail (2.3608.120.23.2.7) X-Classification-ID: d98957af-29b8-404f-93ae-9c6783457953-1-1 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Nov 2, 2023, at 23:26, Kar, Swapnil (TR Technology) = wrote: > We want Support users to have no SELECT or DML privilege but only = ALTER TABLE to perform any troubleshooting in the database. If a user has no ability to do SELECT or DML, they won't be able to = "troubleshoot" the database. They may be able to apply migrations, but = if essentially any problem arises in the database, at least SELECT will = be required.