RE: Using non-Super user with PgAmdin

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(at)venaas(dot)org <mailto:gunnar(at)venaas(dot)org>

932 85 069

From: JP Pozzi <jpp(at)jppozzi(dot)dyndns(dot)org>
Sent: torsdag 8. desember 2022 00:19
To: M Sarwar <sarwarmd02(at)outlook(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)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(at)outlook(dot)com <mailto:sarwarmd02(at)outlook(dot)com> >
À: "pgsql-admin" <pgsql-admin(at)postgresql(dot)org <mailto:pgsql-admin(at)postgresql(dot)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