Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kmkkJ-0007b0-8b for pgsql-admin@arkaria.postgresql.org; Tue, 08 Dec 2020 21:42:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kmkkI-0000Sr-5e for pgsql-admin@arkaria.postgresql.org; Tue, 08 Dec 2020 21:42:06 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kmkkH-0000Sj-RX for pgsql-admin@lists.postgresql.org; Tue, 08 Dec 2020 21:42:05 +0000 Received: from mail-ot1-x335.google.com ([2607:f8b0:4864:20::335]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kmkkF-00034T-Pj for pgsql-admin@lists.postgresql.org; Tue, 08 Dec 2020 21:42:04 +0000 Received: by mail-ot1-x335.google.com with SMTP id f16so156435otl.11 for ; Tue, 08 Dec 2020 13:42:03 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-transfer-encoding:content-language; bh=rINQ+jBPcmukjZ18a5KjjPK5/6QCZKLHKrr4s+t1GrE=; b=UwWr4nZgYR72EDv7bAzXm3qcUF6RBW/EfDCqsuFkJR+1uQW8UCJsyo//rr/stSk5g8 NDfGEb1vO8nPdcaNlYl5NMraKCXBYA8xDePGcoaynrqFWz/nFBrEoPngKdqhzAFoILmO mHW9g1KPZdqzgOsW/zG3QzP6HM0RQ6qwqzrOXpOIt9aqKIsTEFEp9GBoXwNSu3/izeyC 2SjquiXIK1N35NBZ2evFD5wOdX0jeeT3Vs0bILF8cL9E1MfJ0bbpU8SsPBf/8OSyk7Ru 315LAZlRecz5Q9cs1qemz32J+urGVAtpg1T68lwXNmSFN6DuwPg575WXjgJjRzSWIEgR /FKg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=rINQ+jBPcmukjZ18a5KjjPK5/6QCZKLHKrr4s+t1GrE=; b=XSWMn/bFPgikZe9MU5wKfaR+vuzxTMALtFIYsXet7+z1LHC/Hop24Qc6Evw4naitMd tzMbVpwv1k4RunfYd6fcLWJnGLQHF4WELOGklEDUBHmWtnivSQP2qAehvNJnEw9F4IVr awlY46P9ugf6yTWXeQ+DZ8i66xg8K68i2p5xeAnD9dyPZmr2CZHoIMskRQ4Ad6NFwFal xFy0Ak3B+7vgxVbzLUquCCOmX+CvMXYsZTf7+Wj8Ky9vOU9yKbLdpoGRQHdSiWHVdsuh weoXcCXR6i6EXM3aoIKCSfule1/8damcQ4/X3eezgX5JlRZ0SZeEwK3l66O9pEPtP+8l m0Og== X-Gm-Message-State: AOAM530e/bJt6tWlR9imc5/wq2MPNkOwcm5oyKM2TRq413axZdHSANKE lx0KSzzMja8IT7nBx61Xhx6lp8GOLIFWAA== X-Google-Smtp-Source: ABdhPJyqWwQlDgMTQm9AuRz7N/WV2h9jbf+V78O8cp0BXN0Uym8Qb0Ek0O7ZMN8Uu/AOHxQDWFXrog== X-Received: by 2002:a05:6830:159a:: with SMTP id i26mr33948otr.315.1607463658653; Tue, 08 Dec 2020 13:40:58 -0800 (PST) Received: from [192.168.1.10] (ip174-67-141-204.no.no.cox.net. [174.67.141.204]) by smtp.googlemail.com with ESMTPSA id d13sm3692783oti.74.2020.12.08.13.40.57 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 08 Dec 2020 13:40:58 -0800 (PST) Subject: Re: LDAP and roles To: Pgsql-admin References: <487c76f4-185c-b712-2d22-a6e6e9b86c6b@gmail.com> <3268038.1607462137@sss.pgh.pa.us> From: Ron Message-ID: <446f60d7-6535-9b86-c0c3-9c1e1d07177d@gmail.com> Date: Tue, 8 Dec 2020 15:40:57 -0600 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.10.0 MIME-Version: 1.0 In-Reply-To: <3268038.1607462137@sss.pgh.pa.us> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 12/8/20 3:15 PM, Tom Lane wrote: > Ron writes: >> Does LDAP obviate the need for the PASSWORD clause of CREATE ROLE? > Well, it won't use that password, if that's what you mean. That's what I meant. -- Angular momentum makes the world go 'round.