RE: Using non-Super user with PgAmdin - Mailing list pgsql-admin

From Gunnar Venaas
Subject RE: Using non-Super user with PgAmdin
Date
Msg-id 00b501d90b38$85dd5790$919806b0$@venaas.org
Whole thread Raw
In response to Re: Using non-Super user with PgAmdin  (JP Pozzi <jpp@jppozzi.dyndns.org>)
List pgsql-admin

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

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>
À: "pgsql-admin" <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

 

 

pgsql-admin by date:

Previous
From: Satalabaha Postgres
Date:
Subject: backend_xid and backend_xmin
Next
From: Laurenz Albe
Date:
Subject: Re: backend_xid and backend_xmin