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 1l36lC-00018o-AI for pgsql-admin@arkaria.postgresql.org; Sat, 23 Jan 2021 00:26:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l36lB-0002jT-7T for pgsql-admin@arkaria.postgresql.org; Sat, 23 Jan 2021 00:26:37 +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 1l36lB-0002jL-0R for pgsql-admin@lists.postgresql.org; Sat, 23 Jan 2021 00:26:37 +0000 Received: from mail-oi1-x231.google.com ([2607:f8b0:4864:20::231]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1l36l9-0004pR-5I for pgsql-admin@lists.postgresql.org; Sat, 23 Jan 2021 00:26:36 +0000 Received: by mail-oi1-x231.google.com with SMTP id h192so8065405oib.1 for ; Fri, 22 Jan 2021 16:26:34 -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=SvZWl2bG33wl+FQtm3I5/p39V+27HULWa/RDYnfTpWQ=; b=oQxukhqmP14OgHTbHPa7Yuhmj86vTjTAVn19MNNRqkrA67/nQPILyfJt18J7S1DeaU OZsKAqP31srFu4NlxoYDIo6oMAz5oUb05vZlg3Ubk87eP7U99G+fUHa624/9lSTkwTnl Cdn+TXWyaw+dow6bFqZgqgtC3/V9ef7xlssXi4puxbYNqT9U0beSxZivO8WiteyAw7gT NeLVikwH78unStymyRoBBTxYPQ2GoKH+pUS6kudaPIzDUIDfWmiHsiU4hAQ5Bfie5qyJ xdXDV4W0At8nDKTI8veEHoUY7/4XSHZARULhqTdANIxf+/RxwrswZwwAL2/365c3grH6 ISgQ== 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=SvZWl2bG33wl+FQtm3I5/p39V+27HULWa/RDYnfTpWQ=; b=NLhntXxKWx56YT1jT1V0jY6k0zjBwSBF8asNbUYMO//EKWNE+uKkKycZSBHMYE2Dtf shvOuzHCgUZVnJI7S1h6tFm7Trtnr2SK4uDapPNDY8J+W5PkwdBTxwGMsj9RqxENCJ/u LAIPrtt7bp46sGm6AE+Z2VFJysr4dME04c7kjOnuDOYsdqG7P/SR+/JLDx/Unv04yLg2 AEdnha1o5S8MlyhuUtxvLHCQLgutYFPhpAChxsw3UmxvQ8fCPT9UDXy8WQUZ4b9JY+r7 nMkh1I7VLA1c1hApgLWDXYeJko6EiioCHNfNBKKM4OeMHwyQqc/z3SF2BQQ/LtvdRkZY BLzw== X-Gm-Message-State: AOAM533ZgcPIVJra0yysrAEi+8PkcVq5BT2fwabdllxKEtgJ1UK6MtZk n1HC1XSDQlX2NvrKvseEIlJf7mfQ7K+jiQ== X-Google-Smtp-Source: ABdhPJyOwNmDuIzTV+vUrVrrj+TARwaXaCoHky2fcykxb2lwK5QkAUKvzLiV2HtWeq8zRwT2ZllLtg== X-Received: by 2002:aca:c756:: with SMTP id x83mr4707016oif.4.1611361592984; Fri, 22 Jan 2021 16:26:32 -0800 (PST) Received: from [192.168.88.10] (ip174-67-141-204.no.no.cox.net. [174.67.141.204]) by smtp.googlemail.com with ESMTPSA id j17sm1999477otj.52.2021.01.22.16.26.32 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 22 Jan 2021 16:26:32 -0800 (PST) Subject: Re: Create Read only user To: pgsql-admin@lists.postgresql.org References: <87bldgbv9r.fsf@gmail.com> <9e9f3cd6-bd51-29b3-887e-c3af2db91f54@jakobs.com> From: Ron Message-ID: <52456e0f-61ff-60b6-8934-9fcd18efcdb6@gmail.com> Date: Fri, 22 Jan 2021 18:26:31 -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: <9e9f3cd6-bd51-29b3-887e-c3af2db91f54@jakobs.com> 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 1/22/21 2:09 PM, Holger Jakobs wrote: [snip] > Actually, this only exists to be compatible with *very* old applications. And new applications written by people who don't know this, and so put all their tables in public. -- Angular momentum makes the world go 'round.