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 1p3Kol-0006Kp-3J for pgsql-admin@arkaria.postgresql.org; Thu, 08 Dec 2022 17:36:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p3Koj-0002BV-1Q for pgsql-admin@arkaria.postgresql.org; Thu, 08 Dec 2022 17:36:17 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p33gV-0002dn-D4 for pgsql-admin@lists.postgresql.org; Wed, 07 Dec 2022 23:18:39 +0000 Received: from mail-cy.bbox.fr ([194.158.98.48]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p33gS-0002H3-Qn for pgsql-admin@postgresql.org; Wed, 07 Dec 2022 23:18:38 +0000 Received: from mail.jppozzi.dyndns.org (176-172-74-140.abo.bbox.fr [176.172.74.140]) by mail-cy.bbox.fr (Postfix) with ESMTP id 82AC33F; Thu, 8 Dec 2022 00:18:34 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by mail.jppozzi.dyndns.org (Postfix) with ESMTP id 44F98300364; Thu, 8 Dec 2022 00:18:34 +0100 (CET) Received: from mail.jppozzi.dyndns.org ([127.0.0.1]) by localhost (mail.jppozzi.dyndns.org [127.0.0.1]) (amavisd-new, port 10032) with ESMTP id imXszSgm4Dc9; Thu, 8 Dec 2022 00:18:34 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by mail.jppozzi.dyndns.org (Postfix) with ESMTP id 0843A300365; Thu, 8 Dec 2022 00:18:34 +0100 (CET) X-Virus-Scanned: amavisd-new at mail.jppozzi.dyndns.org Received: from mail.jppozzi.dyndns.org ([127.0.0.1]) by localhost (mail.jppozzi.dyndns.org [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id 63EpC0T45IP9; Thu, 8 Dec 2022 00:18:33 +0100 (CET) Received: from mail.jppozzi.dyndns.org (mail.jpp.fr [192.168.2.21]) by mail.jppozzi.dyndns.org (Postfix) with ESMTP id E529F300364; Thu, 8 Dec 2022 00:18:33 +0100 (CET) Date: Thu, 8 Dec 2022 00:18:33 +0100 (CET) From: JP Pozzi To: M Sarwar Cc: pgsql-admin Message-ID: <1248013365.2011.1670455113858.JavaMail.zimbra@jppozzi.dyndns.org> In-Reply-To: References: Subject: Re: Using non-Super user with PgAmdin MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_16f463bd-f68c-4224-8a71-ed3216fa6055" X-Originating-IP: [192.168.2.8] X-Mailer: Zimbra 8.8.15_GA_4481 (ZimbraWebClient - FF102 (Linux)/8.8.15_GA_4481) Thread-Topic: Using non-Super user with PgAmdin Thread-Index: AQHZCo+nu3klq9E8mE6P0XoWyrkpLdA5veUz X-VADE-SPAMSTATE: clean X-VADE-SPAMSCORE: -100 X-VADE-SPAMCAUSE: gggruggvucftvghtrhhoucdtuddrgedvhedrudelgddutdcutefuodetggdotefrodftvfcurfhrohhfihhlvgemuceuqfgfjgfifgfgufdpucfqfgfvpdcuggftfghnshhusghstghrihgsvgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujfgurhepfffhvfevkfgjfhfugggtihfothesrgdttgerredtjeenucfhrhhomheplffrucfrohiiiihiuceojhhpphesjhhpphhoiiiiihdrugihnhgunhhsrdhorhhgqeenucggtffrrghtthgvrhhnpefgtedvhffgffdtvedvueehueeiudejffeggfffhfejlefgjeeihedtieejuddvffenucfkphepudejiedrudejvddrjeegrddugedtpdduledvrdduieekrddvrdeknecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehinhgvthepudejiedrudejvddrjeegrddugedtpdhhvghlohepmhgrihhlrdhjphhpohiiiihirdguhihnughnshdrohhrghdpmhgrihhlfhhrohhmpehjphhpsehjphhpohiiiihirdguhihnughnshdrohhrghdpnhgspghrtghpthhtohepvddprhgtphhtthhopehsrghrfigrrhhmugdtvdesohhuthhlohhokhdrtghomhdprhgtphhtthhopehpghhsqhhlqdgrughmihhnsehpohhsthhgrhgvshhqlhdrohhrgh List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=_16f463bd-f68c-4224-8a71-ed3216fa6055 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hello,=20 It's quite normal and smart not to give developers superuser rights and Pga= dmin is OK with that.=20 Regards=20 JP P=20 De: "M Sarwar" =20 =C3=80: "pgsql-admin" =20 Envoy=C3=A9: Jeudi 8 D=C3=A9cembre 2022 00:00:09=20 Objet: Using non-Super user with PgAmdin=20 Hello All,=20 After working in the databases for the decades, recently I started a projec= t postgress side newly.=20 I have a question on pgadmin access.=20 Can I use other than super user to login into pgadmin?=20 I am trying to provide access to all the development team members without g= iving them access to super user, postgress.=20 Thanks,=20 Sarwar=20 8 times ocp dba=20 3 cloud certificates=20 --=_16f463bd-f68c-4224-8a71-ed3216fa6055 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Hello,

It's quite normal and smart not to give developers superuser rights and P= gadmin is OK with that.

Regards

JP P


De: "M Sarwar" <sarwarmd0= 2@outlook.com>
=C3=80: "pgsql-admin" <pgsql-admin@postgresq= l.org>
Envoy=C3=A9: Jeudi 8 D=C3=A9cembre 2022 00:00:09
= Objet: Using non-Super user with PgAmdin

Hello All,
After working in the databa= ses for the decades, recently I started a project postgress side newly.
I have a question on pgadmi= n access.
Can I use other than super = user to login into pgadmin?
I am trying to provide acce= ss to all the development team members without giving them access to super user, postgress.
Thanks,
Sarwar
8 times ocp dba
3 cloud certificates


--=_16f463bd-f68c-4224-8a71-ed3216fa6055--