Re: [pgadmin-support] pgadmin4 login page - Mailing list pgadmin-support

From Peter S. Shenkin
Subject Re: [pgadmin-support] pgadmin4 login page
Date
Msg-id CAAsqebGp=1OO2EE4yB4+w110+X5=wwHZhcbOLRPxNUZ9qsn2Zw@mail.gmail.com
Whole thread Raw
In response to [pgadmin-support] pgadmin4 login page  (Brent Vaughn <Vaughn@climatecontrolgroup.com>)
List pgadmin-support
​I'm a newbie at DB admin and have been trying to understand similar issues. So the following might not be completely right; but hopefully it's a step in the right direction and someone with more experience can amplify or correct.

My sense is that what PostgreSQL expects you to do is to GRANT permissions to specific users for specific actions. If someone can make changes from pgAdmin that you don't think they should be allowed to make, it presumably indicates that permissions have been GRANTed them in the underlying DB that shouldn't have been.

I find that if I run pgAdmin as a "regular" user and then try to do something that only a privileged user can do, I get a login screen to enter the "postgres" password. Right now, the only users I have are peons and postgres, so I don't know how this extends to those with intermediate levels of privilege.

-P.

pgadmin-support by date:

Previous
From: Brent Vaughn
Date:
Subject: [pgadmin-support] pgadmin4 login page
Next
From: Khushboo Vashi
Date:
Subject: Re: [pgadmin-support] pgadmin4 login page