Re: Integrating Postgresql with Active Directory

Hi Korry
Thanks for the link. After looking at the instructions I have a question. Will this setup which uses an AD services account allow me to grant user access to postgresql directly to an AD group by adding a group role to postgresql?

Doug Brown
Senior Database Consultant
McBee
P: 610.964.9680, ext. 4441
C:267-971-9300
E: douglasbrown(at)mcbeeassociates(dot)com<mailto:douglasbrown(at)mcbeeassociates(dot)com>

[YouTube-social-squircle_red_24px]<https://www.youtube.com/channel/UCvfSpkJHnJ3j7M-me7iVQbA/featured>[cid:image002(dot)png(at)01D1A6B2(dot)3421E0C0]<http://www.mcbeeassociates.com/> [cid:image003(dot)jpg(at)01D1A6B2(dot)3421E0C0] <https://twitter.com/McBeeAssociates> [cid:image004(dot)png(at)01D1A6B2(dot)3421E0C0] <https://www.linkedin.com/company/mcbee-associates-inc-_2> [cid:image005(dot)png(at)01D1A6B2(dot)3421E0C0] <https://www.facebook.com/McBeeAssociates/?fref=ts>

From: Korry Douglas [mailto:korry(dot)douglas(at)enterprisedb(dot)com]
Sent: Tuesday, March 28, 2017 11:52 AM
To: Douglas Brown <DouglasBrown(at)McBeeAssociates(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Integrating Postgresql with Active Directory

This may help: https://wiki.postgresql.org/wiki/Configuring_for_single_sign-on_using_SSPI_on_Windows

-- Korry

On Mon, Mar 27, 2017 at 12:27 PM, Douglas Brown <DouglasBrown(at)mcbeeassociates(dot)com<mailto:DouglasBrown(at)mcbeeassociates(dot)com>> wrote:
Hi
I have installed Postgresql 9.6 on Windows Server 2012. Is there a way to integrate login access of the databases to active directory.

Doug Brown
Senior Database Consultant
McBee
P: 610.964.9680, ext. 4441<tel:(610)%20964-9680>
C:267-971-9300<tel:(267)%20971-9300>
E: douglasbrown(at)mcbeeassociates(dot)com<mailto:douglasbrown(at)mcbeeassociates(dot)com>

[YouTube-social-squircle_red_24px]<https://www.youtube.com/channel/UCvfSpkJHnJ3j7M-me7iVQbA/featured>[cid:image002(dot)png(at)01D1A6B2(dot)3421E0C0]<http://www.mcbeeassociates.com/> [cid:image003(dot)jpg(at)01D1A6B2(dot)3421E0C0] <https://twitter.com/McBeeAssociates> [cid:image004(dot)png(at)01D1A6B2(dot)3421E0C0] <https://www.linkedin.com/company/mcbee-associates-inc-_2> [cid:image005(dot)png(at)01D1A6B2(dot)3421E0C0] <https://www.facebook.com/McBeeAssociates/?fref=ts>

----------------------------------------------------

McBee Associates, Inc. - This message and any attachments are intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender by replying to this message, and then delete it from your system.

Nothing in this e-mail message is intended to constitute an e-signature, nor does the content hereof create a binding offer or contract

----------------------------------------------------

McBee Associates, Inc. - This message and any attachments are intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender by replying to this message, and then delete it from your system.

Nothing in this e-mail message is intended to constitute an e-signature, nor does the content hereof create a binding offer or contract