Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gQGdr-0001vN-Qq for pgsql-admin@arkaria.postgresql.org; Fri, 23 Nov 2018 18:57:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gQGdo-0008WF-CV for pgsql-admin@arkaria.postgresql.org; Fri, 23 Nov 2018 18:57:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gQGdo-0008Vh-4U for pgsql-admin@lists.postgresql.org; Fri, 23 Nov 2018 18:57:24 +0000 Received: from mtaextp1.scidom.de ([146.107.103.20]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gQGdh-0005hH-N8 for pgsql-admin@lists.postgresql.org; Fri, 23 Nov 2018 18:57:23 +0000 Received: from localhost (localhost [127.0.0.1]) by mtaextp1.scidom.de (Postfix) with ESMTP id 113DA14E308; Fri, 23 Nov 2018 19:57:16 +0100 (CET) Received: from mtaextp1.scidom.de ([127.0.0.1]) by localhost (mtaextp1.scidom.de [127.0.0.1]) (amavisd-new, port 10032) with ESMTP id Gq3VBD-_6idj; Fri, 23 Nov 2018 19:57:15 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by mtaextp1.scidom.de (Postfix) with ESMTP id 27B8B14E438; Fri, 23 Nov 2018 19:57:15 +0100 (CET) X-Amavis-Modified: Mail body modified (using disclaimer) - mtaextp1.scidom.de X-Virus-Scanned: amavisd-new at mtaextp1.scidom.de Received: from mtaextp1.scidom.de ([127.0.0.1]) by localhost (mtaextp1.scidom.de [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id EK1S7tKJ5TMr; Fri, 23 Nov 2018 19:57:15 +0100 (CET) Received: from mtaintp1.scidom.de (mtaintp1.scidom.de [146.107.8.104]) by mtaextp1.scidom.de (Postfix) with ESMTPS id 0005514E308; Fri, 23 Nov 2018 19:57:14 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by mtaintp1.scidom.de (Postfix) with ESMTP id E8A151003A2; Fri, 23 Nov 2018 19:57:14 +0100 (CET) Received: from mtaintp1.scidom.de ([127.0.0.1]) by localhost (mtaintp1.scidom.de [127.0.0.1]) (amavisd-new, port 10032) with ESMTP id g1x9ew_r7bSU; Fri, 23 Nov 2018 19:57:14 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by mtaintp1.scidom.de (Postfix) with ESMTP id 644C5101967; Fri, 23 Nov 2018 19:57:14 +0100 (CET) X-Amavis-Modified: Mail body modified (using disclaimer) - mtaintp1.scidom.de X-Virus-Scanned: amavisd-new at mtaintp1.scidom.de Received: from mtaintp1.scidom.de ([127.0.0.1]) by localhost (mtaintp1.scidom.de [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id qJ0gWwrSw70p; Fri, 23 Nov 2018 19:57:14 +0100 (CET) Received: from mbxp1.scidom.de (mbxp1.scidom.de [146.107.8.101]) by mtaintp1.scidom.de (Postfix) with ESMTP id 2AAE71003A2; Fri, 23 Nov 2018 19:57:14 +0100 (CET) Date: Fri, 23 Nov 2018 19:57:13 +0100 (CET) From: "Lentes, Bernd" To: Stephen Frost Cc: pgsql-admin Message-ID: <448603474.21010176.1542999433914.JavaMail.zimbra@helmholtz-muenchen.de> In-Reply-To: <20181123151725.GH3415@tamriel.snowman.net> References: <1819852155.20922807.1542983802608.JavaMail.zimbra@helmholtz-muenchen.de> <20181123151725.GH3415@tamriel.snowman.net> Subject: Re: User Authentication: LDAP and "local" accounts concurrently ? MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Originating-IP: [146.107.8.103] X-Mailer: Zimbra 8.7.11_GA_2038 (ZimbraWebClient - GC70 (Win)/8.7.11_GA_1854) Thread-Topic: User Authentication: LDAP and "local" accounts concurrently ? Thread-Index: GIQNlQvBLmOpHZx5bKHdghu82SSVuA== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ----- On Nov 23, 2018, at 4:17 PM, Stephen Frost sfrost@snowman.net wrote: > Greetings, > > * Lentes, Bernd (bernd.lentes@helmholtz-muenchen.de) wrote: >> i created a Postgres Server 9.6 on a SLES 12 SP3 box. In our institution we have >> a Windows ADS which i like to use to authenticate users via LDAP. > > For running PostgreSQL in a Windows ADS environment, you should really > be using GSSAPI / Kerberos and *not* using LDAP authentication. > > GSSAPI / Kerberos is what Windows uses to authenticate users and > services and it's much more secure than using LDAP. Hi Stephen, thanks for your answer. I'm not familiar with LDAP, GSSAPI and Kerberos. Why is it more secure ? Bernd Helmholtz Zentrum Muenchen Deutsches Forschungszentrum fuer Gesundheit und Umwelt (GmbH) Ingolstaedter Landstr. 1 85764 Neuherberg www.helmholtz-muenchen.de Aufsichtsratsvorsitzende: MinDirig.in Petra Steiner-Hoffmann Stellv.Aufsichtsratsvorsitzender: MinDirig. Dr. Manfred Wolter Geschaeftsfuehrer: Prof. Dr. med. Dr. h.c. Matthias Tschoep, Heinrich Bassler, Dr. rer. nat. Alfons Enhsen Registergericht: Amtsgericht Muenchen HRB 6466 USt-IdNr: DE 129521671