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 1kmjLk-0004Lu-PR for pgsql-admin@arkaria.postgresql.org; Tue, 08 Dec 2020 20:12:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kmjLj-0006xc-Oe for pgsql-admin@arkaria.postgresql.org; Tue, 08 Dec 2020 20:12:39 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kmjLj-0006xV-FO for pgsql-admin@lists.postgresql.org; Tue, 08 Dec 2020 20:12:39 +0000 Received: from mail-ot1-x332.google.com ([2607:f8b0:4864:20::332]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kmjLh-0004RY-3E for pgsql-admin@lists.postgresql.org; Tue, 08 Dec 2020 20:12:39 +0000 Received: by mail-ot1-x332.google.com with SMTP id b18so17031630ots.0 for ; Tue, 08 Dec 2020 12:12:36 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=to:from:subject:message-id:date:user-agent:mime-version :content-transfer-encoding:content-language; bh=Gzub4OVXymHhYacv7XowhEvLVQAZIGj/QTpix6Xrh+o=; b=dotFJhrdyU3YWi2j+jXvUWhaLKJqwOztlFGlXuR1KGbunNzQQqbuc4rJ/bFnRcCeTJ wKYnEoHWX7vuQQqNOAmSNcIe5xsEnj6/VUgw8+3ss8iOVhuuuWR1mAcyDY1PSn4yWidw 7+ouf6/9AZ0OaAS89rJeLk671gP6Ma+RBK91qKcQqVmfjTXt02X//mCsjecHAJLWvp2T 2957u9GWke0LB8Yw0vlnmSeySiDtxpGwysEeWzQaYyXcLNO13PLZhdXSrG/XSrCUM3DP 5UPO+CWMEw8a3t/ga9z/W4IkiDL6N4gDsV2l/Jfv9FZOT6Eql9tjfS/KUoAzO1766FJz ANAQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:to:from:subject:message-id:date:user-agent :mime-version:content-transfer-encoding:content-language; bh=Gzub4OVXymHhYacv7XowhEvLVQAZIGj/QTpix6Xrh+o=; b=TEDvlGFLZJjNI4BsIV2JMPGVpyG1W9bOa9JGKyvPIQRWOk5Nqq/V+r384YN4EJL+x7 sHvLYG0EiQXPb0Znl/P+20VW9kxYxRW9wRgtpv4kztISlzKzd8uatrM5GyelzCj/Fuei 2UAxRwbnnfuoY7lUx8e5LymrvyDmxaxb9A/yOcJ/9plUXnLj+eqRdGKyheBP6SEbEpGd dtyaeK1jH3Hf2YPtxZI6txxW+Wlh0MlujZxIj9CTbYyXfNZYAI7o7T8NLfmkop6ivOYr GubpwO4V//85lxZ1V9crbJtR7KGeXKMqUaXUAQUkgtx2nSIu+REpojxXOx1dQUBjwo8C PFxA== X-Gm-Message-State: AOAM531eLd5J2DhrRTYVrcdnEhpAWW2Ufqu6hHS+SXxLs1I4lAomKR9o ieE++IwB4e3VgZKWsbkzV9q8FPTS4obJvw== X-Google-Smtp-Source: ABdhPJw9AKDYOUlGDCR4FkTqXqhXOTk4tmp2cOUt20ZLU5irLJOW975gVG+FR/5jTs6UcD5187CjaA== X-Received: by 2002:a9d:5613:: with SMTP id e19mr17985434oti.153.1607458355301; Tue, 08 Dec 2020 12:12:35 -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 o82sm3781323oih.5.2020.12.08.12.12.34 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 08 Dec 2020 12:12:34 -0800 (PST) To: Pgsql-admin From: Ron Subject: LDAP and roles Message-ID: <487c76f4-185c-b712-2d22-a6e6e9b86c6b@gmail.com> Date: Tue, 8 Dec 2020 14:12:33 -0600 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.10.0 MIME-Version: 1.0 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 Does LDAP obviate the need for the PASSWORD clause of CREATE ROLE? It sounds obvious, but I wanted to verify before deciding whether or not to try LDAP, and did not see any reference in https://www.postgresql.org/docs/12/sql-createrole.html. Thanks -- Angular momentum makes the world go 'round.