From: Gunnar Venaas <gunnar@venaas.org>
To: 'JP Pozzi' <jpp@jppozzi.dyndns.org>
To: 'M Sarwar' <sarwarmd02@outlook.com>
Cc: 'pgsql-admin' <pgsql-admin@postgresql.org>
Subject: RE: Using non-Super user with PgAmdin
Date: Thu, 8 Dec 2022 20:08:57 +0100
Message-ID: <00b501d90b38$85dd5790$919806b0$@venaas.org> (raw)
In-Reply-To: <1248013365.2011.1670455113858.JavaMail.zimbra@jppozzi.dyndns.org>
References: <CAHJZqBCWK8thYBSLsAQrq=k4tN1AHV9RRd5yVEEcziQuwLb8sQ@mail.gmail.com>
<CAMkU=1ybQA6cGN_boRF1-W4rjqesM=F+u4eZ2Wfw7_KoT9wvrA@mail.gmail.com>
<CAHJZqBBqdH63TyFRB0dJxDCCRLwtJHHMa3gBbvWSPqXTTeDc4Q@mail.gmail.com>
<DM4PR19MB59781B9093A74C1FE1A243CFD31A9@DM4PR19MB5978.namprd19.prod.outlook.com>
<1248013365.2011.1670455113858.JavaMail.zimbra@jppozzi.dyndns.org>
This is not a “smart” approach.
The application should run with “least privilege”, and the developers should develop within the same context.
There are far to many applications that demands some sort of elevated permissions to work.
Gunnar Venaas
gunnar@venaas.org <mailto:gunnar@venaas.org>
932 85 069
From: JP Pozzi <jpp@jppozzi.dyndns.org>
Sent: torsdag 8. desember 2022 00:19
To: M Sarwar <sarwarmd02@outlook.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Using non-Super user with PgAmdin
Hello,
It's quite normal and smart not to give developers superuser rights and Pgadmin is OK with that.
Regards
JP P
_____
De: "M Sarwar" <sarwarmd02@outlook.com <mailto:sarwarmd02@outlook.com> >
À: "pgsql-admin" <pgsql-admin@postgresql.org <mailto:pgsql-admin@postgresql.org> >
Envoyé: Jeudi 8 Décembre 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 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 giving them access to super user, postgress.
Thanks,
Sarwar
8 times ocp dba
3 cloud certificates
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gunnar@venaas.org, jpp@jppozzi.dyndns.org, sarwarmd02@outlook.com
Subject: RE: Using non-Super user with PgAmdin
In-Reply-To: <00b501d90b38$85dd5790$919806b0$@venaas.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox