public inbox for [email protected]  
help / color / mirror / Atom feed
Pgadmin4 Webserver Authentication + Azure SAML SSO , anyone ever managed to configure it?
3+ messages / 3 participants
[nested] [flat]

* Pgadmin4 Webserver Authentication + Azure SAML SSO , anyone ever managed to configure it?
@ 2025-03-29 11:09  Viktor Madarasz <[email protected]>
  0 siblings, 2 replies; 3+ messages in thread

From: Viktor Madarasz @ 2025-03-29 11:09 UTC (permalink / raw)
  To: [email protected] <[email protected]>

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 [email protected] 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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Pgadmin4 Webserver Authentication + Azure SAML SSO , anyone ever managed to configure it?
@ 2025-04-01 04:30  Yogesh Mahajan <[email protected]>
  parent: Viktor Madarasz <[email protected]>
  1 sibling, 0 replies; 3+ messages in thread

From: Yogesh Mahajan @ 2025-04-01 04:30 UTC (permalink / raw)
  To: Viktor Madarasz <[email protected]>; +Cc: [email protected] <[email protected]>

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 <[email protected]>
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 [email protected] 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
>
>
>


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Pgadmin4 Webserver Authentication + Azure SAML SSO , anyone ever managed to configure it?
@ 2025-04-01 05:40  Khushboo Vashi <[email protected]>
  parent: Viktor Madarasz <[email protected]>
  1 sibling, 0 replies; 3+ messages in thread

From: Khushboo Vashi @ 2025-04-01 05:40 UTC (permalink / raw)
  To: Viktor Madarasz <[email protected]>; +Cc: [email protected] <[email protected]>

Hi,

On Mon, Mar 31, 2025 at 6:26 PM Viktor Madarasz <[email protected]>
wrote:

> Hi
>
> Pgadmin4 Webserver Authentication + Azure SAML SSO , anyone ever managed
> to configure it?
>
> As Yogesh said, Azure SSO with pgAdmin 4 OAuth2 authentication is very
common, but we never tried Azure SSO with Webserver.
Please provide your pgAdmin configuration file and Azure SSO configuration
so we can understand how you would like to configure it.

Thanks,
Khushboo

> 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 [email protected] 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
>
>
>


^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2025-04-01 05:40 UTC | newest]

Thread overview: 3+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-03-29 11:09 Pgadmin4 Webserver Authentication + Azure SAML SSO , anyone ever managed to configure it? Viktor Madarasz <[email protected]>
2025-04-01 04:30 ` Yogesh Mahajan <[email protected]>
2025-04-01 05:40 ` Khushboo Vashi <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox