[SSPI] Windows group support

From: The Dude <russman7474(at)gmail(dot)com>
To: pgadmin-hackers(at)lists(dot)postgresql(dot)org
Subject: [SSPI] Windows group support
Date: 2020-04-21 13:33:59
Message-ID: CA+bhM4J+Zu9Kj=GM7y0tKsXJEzq3WZK-UiBM5U1qVdwT+gLVrw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Hi,

I have some code that I've been using in production that supports adding
and authenticating Windows groups via the pg_ident file. It has a new
indicator (+), that signifies the identifier is a Windows group, as in the
following example:

# MAPNAME SYSTEM-USERNAME PG-USERNAME
"Users" "+User group" postgres

A new function was added to test if a user token is in the windows group:

/*
* Check if the user (sspiToken) is a member of the specified group
*/
static BOOL
sspi_user_is_in_group(HANDLE sspiToken, LPCTSTR groupName)

I wanted to share this as a patch for the latest, as soon as I port it to
v12. Does this sound reasonable?

thanks,
Russell

Browse pgadmin-hackers by date

  From Date Subject
Next Message Yogesh Jain 2020-04-21 13:54:28 Re: [pgAdmin][RM5352] : Rightmost & Bottom tooltip crop issues in Explain Query Plan
Previous Message Khushboo Vashi 2020-04-21 13:02:30 Re: [pgAdmin][RM5157] Default sort order at start in view table data by primary key by default