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 1p34C1-00061c-PJ for pgsql-admin@arkaria.postgresql.org; Wed, 07 Dec 2022 23:51:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p34C0-00029v-BA for pgsql-admin@arkaria.postgresql.org; Wed, 07 Dec 2022 23:51:12 +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 1p34Bz-00029g-EK for pgsql-admin@lists.postgresql.org; Wed, 07 Dec 2022 23:51:12 +0000 Received: from mail-dm6nam12olkn20823.outbound.protection.outlook.com ([2a01:111:f400:fe59::823] helo=NAM12-DM6-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p34Bu-000797-Fp for pgsql-admin@postgresql.org; Wed, 07 Dec 2022 23:51:09 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=hqltZ6kLnvFyELzwXS6iQAF0f7cvbRT107uGppvs7d1Ri+xm7S84UjSqfcC9tBrJxYD5LD27vBJ6gRW6IoCIFV9su+xo20/XsE0dF1IHQnTRLxKmwSuBMEq4IquzAl/EjIXXWldZ/P2XYk22RZq02u79QOfcF9V5QzDELZc9UZLrGmQQHi3oUYsMxVlVj6xh6OiGFx+mDN/g5QjJkrVfldcnSzKeWyhRfj7tQH9edZjE0DbbzLZaVJP+Awq/qdu/F9KDYe8v606+IkLYnxl5uig3m8Xzgw7GFl4dTLHBUQvkAUcdhHHQz0UKHj453pAXSblbE11NV4X2xdzZD0h1eg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=+B9mln+LODINu9B9IxxcgCPL3NFs+DV3iUivoJ+Vj+8=; b=jOYNiSFUjLr1/myL29Fgvhm17tufDuaScFxFiN+wm80/+uyoJfI6t6KQjRqgSCNjRgQhm2QVOApryOuynowuekjCTV8jpqtW5PPlpMPr8SX7su2bpdtk2cw8hHp2xiYTGn44EtXKuF7lYNF/I1V4cNRq7Aqeg5r6MDZd8zJsa2cxIVnHYIj7wnX9gt0zRJG+XRmtPDMso8SULmM90pngmmyk5F1fCjcfSHtwgdrbuJVT1ICrnyW3x1yGPjUxEKEa9iVoUliBFsmXToHUA9WTvAQLGOI+4goNNzhudcDFNqTQbOAiLRNYTt6W0D1hLfPRDDnFOkrEZcsBXTbQyturag== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=outlook.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=+B9mln+LODINu9B9IxxcgCPL3NFs+DV3iUivoJ+Vj+8=; b=SejtRBGGu2GArVGd4uT6Adn/ywBbXlBWjwcoTQDv7hUQvs8f+PnoJ5G1bCorzXR06fF5PEZQ/1AahtteXeWOM9Qp+KeCcAK5fq7ewI4dMX9NNBRx5MeqvAEJl47htFCxTN2W16qqQLtZwNDxkw9Ui9667MmmsT/B6Fqb5wV+1g40Gp+5/JPlT813q6Edqno4enCT/FV//xukXRjkIsvV+/ocEqfBhFCFudv0br6b9nz4oVvc2w8m8jj4BEAVUilzg9Uini+LhFZ7VSI40Bk8uvrA3ebxNtseYW/FfDlaIOLTQC/YtEngOQCDLj49rRtIOStPevx6+k4Q+1j9seDQ6A== Received: from DM4PR19MB5978.namprd19.prod.outlook.com (2603:10b6:8:6a::18) by SA1PR19MB7088.namprd19.prod.outlook.com (2603:10b6:806:2b6::10) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.5880.13; Wed, 7 Dec 2022 23:51:02 +0000 Received: from DM4PR19MB5978.namprd19.prod.outlook.com ([fe80::a0ca:f63c:373e:dad5]) by DM4PR19MB5978.namprd19.prod.outlook.com ([fe80::a0ca:f63c:373e:dad5%5]) with mapi id 15.20.5880.014; Wed, 7 Dec 2022 23:51:02 +0000 From: M Sarwar To: JP Pozzi CC: pgsql-admin Subject: Re: Using non-Super user with PgAmdin Thread-Topic: Using non-Super user with PgAmdin Thread-Index: AQHZCo+nu3klq9E8mE6P0XoWyrkpLdA5veUz3ilYp+c= Date: Wed, 7 Dec 2022 23:51:02 +0000 Message-ID: References: <1248013365.2011.1670455113858.JavaMail.zimbra@jppozzi.dyndns.org> In-Reply-To: <1248013365.2011.1670455113858.JavaMail.zimbra@jppozzi.dyndns.org> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: x-ms-exchange-messagesentrepresentingtype: 1 x-tmn: [X62jDEXa5sVpwSzF5ET2pAXgT3+zIjPoww0J6tQ6pK/l7ec9vb1s9g==] x-ms-publictraffictype: Email x-ms-traffictypediagnostic: DM4PR19MB5978:EE_|SA1PR19MB7088:EE_ x-ms-office365-filtering-correlation-id: e0c8ac60-90ca-4b09-c66c-08dad8ade62a x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: wuxyVqMpXOIJzsDro/lk7IMjvjmBabDGKuJ5YmG644f89CMrd0tfozf58i0V152IOAY1FvZGMen5coDmDreq/z6GmBAE2fmSe/PdAzS5afgjVyXvPq9TA3X2i6qc5J7Z3tNWkfRgTdeuS3gKYehXBZqSP1B1MhKCo773n+h6pXcq8ByAK83QdyRIVY/f/6Ldw51IYj7PB4lPx2CtySGiZ4oix0k5daENhdcqEYsKtkuXuNVb8rmt6AkVFD32RykqmbSNNQNtS+NVBLTzakIbvnCSfbm8lHsJm/xkhHBRya0eQCjuigAHxqslEWqURl7z/knmYinnQHICgEybT8dXxBboLDd1O1EdWikCFtbErUl+WOIKcdEc9ZqqKeLfM6c7WFDbnR3z67+NYGj4Vy1hcm3jSf/a2DRlkADbOWtkgsWgu3A+BEl9ihK2rkEznE0SKvir6i+XDhh0gVBn2qyxx0CujAC/UKIizztJxlcZuTA/ME2E4fH/GCtRQul2maOvYYOpDenLbU3Nk+pdtQVe/Yge7xUABE422bviIcZjlChRcHhL9mK7PWYf8cEUM9zNfjcyjC0aOg7jKLZ/1Ar3UOc4BZIcXy8LF5+Wvv4TTb51nO88evkN0Xf8ukF+HTA8du5qb/2rQxBe0h+d5G6kYA== x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?v0hToDtPYJ7bVJQI2LMf1xW1aW5pH/KyhWI8Gg5wXr8LnwUQOBD8l2P7kL?= =?iso-8859-1?Q?a2LdOHsU+6+ZlopctZqlaMGjYqDWtt0w07f6/cRQZtPmMGAj8tM+CeeCWd?= =?iso-8859-1?Q?b4Tsf+iZstIph9E7hn62N1ZCRwulmxynFwkmRw7qlEPU0FBrvL6AuYSJV/?= =?iso-8859-1?Q?WIYwsIkVzWwkap5PAYkZqM9FkTpuIhmbKUgdfjmyPGft3AFHvrf/933bh6?= =?iso-8859-1?Q?PMp5fzRy8S8hN+R5d8RebXkrw50iQQkDe6jMV3v52GzBe9iMBJqIkOYTgB?= =?iso-8859-1?Q?sWZRoT9CeQGXgOJC/GRSG+2sVIe2MIcuZuqbistNdOG/xJrSje8NwhM7Di?= =?iso-8859-1?Q?XS9HElgShaQ+UlBzdiKf+VsAjyZWeSl2Kd1FRqD8Uggysx56SMicsABPsb?= =?iso-8859-1?Q?fJjtpD8AveHAKe/j2IqaRIxXUk+sRd8FKPeHip4ePIIHAXRvd2VLG3eJ2v?= =?iso-8859-1?Q?cpDKKFCbD+L/HDdPpkeL4J9J47PaiioUbz/eLLep6cx2BdXqJvNLIpds07?= =?iso-8859-1?Q?ozapZrtlWioEowoffhw9Q5uPTX1Nd2VUHWTNvvFYwHZGcJc+L2ljR+4uws?= =?iso-8859-1?Q?+4YeXNmIwhhOHH4e8AYTDjKCVoRVfRgG0gfJrHTRl7FprX8K+ycfvtssO2?= =?iso-8859-1?Q?X9L8FCEOFWeNXjZ/wU+dbL3x8nYmnZUrcmmpHyBSakWI3oZBmVLD1JeJJd?= =?iso-8859-1?Q?OskKbqKu2iI380fpOMnutfWEMt4K/qw5OfRYNFcF28yoK6ahmdCgH8D3id?= =?iso-8859-1?Q?dw128qdT1iHkc+a8vt+ydaxKSwO+zD0YgpBqPgLgLBEBQE69s9np3HQdN9?= =?iso-8859-1?Q?PvKl35REeDbo0xxm09fVTG36DmNbWqOigHYIT5ab+RC+EBz+jV4yaTJXbx?= =?iso-8859-1?Q?vwm2Lbudon2oNVxm7Lr1f4EIJKkknzselSI4H5MyqoLUUwFLZNwO5p+q7A?= =?iso-8859-1?Q?B847dQr0tTLoE2i+F8ZLdmz95GgDhTZ3Whbx3SaeF3dVJwdDZcP+m4Px+Y?= =?iso-8859-1?Q?HkD1TgwhAUEy2k9LP5MzYyEI1gCcXGlVOOy+Cpv9+bAyN0/EZ3NQ2XQiuV?= =?iso-8859-1?Q?SwHzRdfqPv6JQdXq972baJx2O9cz0whoWtdhabmZkJr3AxXuDFo06Wh4/5?= =?iso-8859-1?Q?0W3nrv3ga5SEe/wD+Ih7mIEBiJ/KifGCSxrUSnxpqDU9ZpQvYLLlBzt1wr?= =?iso-8859-1?Q?/pHTZPUegthsENbgJUyVosA74bgiz5AMnL+VY438zyWlntPM3u8y+V6/yt?= =?iso-8859-1?Q?y7kItBEfq1geRwu24iYMOB6Wv2GV+5sGVBFAgVPfB/9Us0rZI6jGy+1e3Q?= =?iso-8859-1?Q?MYwSLiIi7L6clfOxucU2ESXawa2CPsa2Ij79Qa9SBsfo/sQ=3D?= Content-Type: multipart/alternative; boundary="_000_DM4PR19MB597865AC67C826FD2E2D439FD31A9DM4PR19MB5978namp_" MIME-Version: 1.0 X-OriginatorOrg: outlook.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: DM4PR19MB5978.namprd19.prod.outlook.com X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: e0c8ac60-90ca-4b09-c66c-08dad8ade62a X-MS-Exchange-CrossTenant-originalarrivaltime: 07 Dec 2022 23:51:02.8226 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: SA1PR19MB7088 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_DM4PR19MB597865AC67C826FD2E2D439FD31A9DM4PR19MB5978namp_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello JP, I appreciate the response. Actually, I have been spending time on postgress= , pgadmin and google sites could not find help on this. I tried to log off from pgadmin and it is not allowing me to log off pgadmi= n and re-enter the credentials.The only way to log off is CLICK X button of= pgadmin. I have created a user with my name and unable to verify the same using pga= dmin or any other way. For many of you this question is a novice. I am seeking the help after spen= ding sometime on this. You can point me to the document if you or anybody can think of anything or= find it. Thank you! Sarwar ________________________________ From: JP Pozzi Sent: Wednesday, December 7, 2022 6:18 PM To: M Sarwar Cc: pgsql-admin Subject: Re: Using non-Super user with PgAmdin Hello, It's quite normal and smart not to give developers superuser rights and Pga= dmin is OK with that. Regards JP P ________________________________ De: "M Sarwar" =C0: "pgsql-admin" Envoy=E9: Jeudi 8 D=E9cembre 2022 00:00:09 Objet: Using non-Super user with PgAmdin Hello All, After working in the databases for the decades, recently I started a projec= t postgress side newly. I have a question on pgadmin access. Can I use other than super user to login into pgadmin? I am trying to provide access to all the development team members without g= iving them access to super user, postgress. Thanks, Sarwar 8 times ocp dba 3 cloud certificates --_000_DM4PR19MB597865AC67C826FD2E2D439FD31A9DM4PR19MB5978namp_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello JP,
I appreciate the response. Actually, I have been spending = time on postgress, pgadmin and google sites could not find help on this.
I tried to log off from pgadmin and it is not allowing me = to log off pgadmin and re-enter the credentials.The only way to log off is CLICK X button of pgadmin.

I have created a  user with my name and unable to ver= ify the same using pgadmin or any other way.
For many of you this question is a novice. I am seeking th= e help after spending sometime on this.
You can point me to the document if you or anybody can thi= nk of anything or find it.
Thank you!
Sarwar

From: JP Pozzi <jpp@jppo= zzi.dyndns.org>
Sent: Wednesday, December 7, 2022 6:18 PM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Using non-Super user with PgAmdin
 
Hello,

<= span class=3D"x_ryNqvb">It's quite normal and smart not to give developers = superuser rights and Pgadmin is OK with that.
<= span class=3D"x_ryNqvb">
<= span class=3D"x_ryNqvb">Regards
<= span class=3D"x_ryNqvb">
<= span class=3D"x_ryNqvb">JP P

De: "M Sarwar" <sarwar= md02@outlook.com>
=C0: "pgsql-admin" <pgsql-admin@postgresql.org>
Envoy=E9: Jeudi 8 D=E9cembre 2022 00:00:09
Objet: Using non-Super user with PgAmdin

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


--_000_DM4PR19MB597865AC67C826FD2E2D439FD31A9DM4PR19MB5978namp_--