Re: Pgadmin4 Webserver Authentication + Azure SAML SSO , anyone ever managed to configure it?

From: Yogesh Mahajan <yogesh(dot)mahajan(at)enterprisedb(dot)com>
To: Viktor Madarasz <viktor(dot)madarasz(at)yahoo(dot)com>
Cc: "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Re: Pgadmin4 Webserver Authentication + Azure SAML SSO , anyone ever managed to configure it?
Date: 2025-04-01 04:30:02
Message-ID: CAMa=N=N3-Xf0yQs_KES5Gcx6cwX-XWOS+-06s6XACf-F7SiT-w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,

pgadmin4 only uses Azure AD for authentication. However users logged in
with Azure SSO(or any OAuth2) are the normal users who have all the access
other than adding new users.
Not sure what exactly you mean 'Read only profiles'? What are the
limitations you have seen in pgadmin?

Thanks,
Yogesh Mahajan
EnterpriseDB

On Mon, Mar 31, 2025 at 6:26 PM Viktor Madarasz <viktor(dot)madarasz(at)yahoo(dot)com>
wrote:

> Hi
>
> Pgadmin4 Webserver Authentication + Azure SAML SSO , anyone ever managed
> to configure it?
>
> Trying to switch IdP Provider from Onelogin ( working right now with
> Pgadmin4 + Webserver Authentication + Onelogin as IdP provider to Azure
> SAML SSO.
>
> It looks like the mapped attributes might be the one causing the issue
> coming from Azure side.
>
> The username in a form of firstname(dot)lastname(at)domain(dot)com gets parsed
> correctly but the actual group memberships not being passed along and
> therefore users being logged in with read only profiles and it does not
> respect their group memberships.
>
> Regards
>
> Viktor
>
>
>

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Khushboo Vashi 2025-04-01 05:40:01 Re: Pgadmin4 Webserver Authentication + Azure SAML SSO , anyone ever managed to configure it?
Previous Message Yogesh Mahajan 2025-04-01 04:21:01 Re: output from pgadmin4 ver 6.14