Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sojcT-00DRPO-VQ for pgsql-general@arkaria.postgresql.org; Thu, 12 Sep 2024 13:12:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sojcS-007lxH-8N for pgsql-general@arkaria.postgresql.org; Thu, 12 Sep 2024 13:12:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sojcR-007lx9-Rd for pgsql-general@lists.postgresql.org; Thu, 12 Sep 2024 13:12:19 +0000 Received: from mail-oo1-xc31.google.com ([2607:f8b0:4864:20::c31]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sojcK-000oyZ-BY for pgsql-general@lists.postgresql.org; Thu, 12 Sep 2024 13:12:19 +0000 Received: by mail-oo1-xc31.google.com with SMTP id 006d021491bc7-5e1c56a8415so418568eaf.3 for ; Thu, 12 Sep 2024 06:12:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1726146732; x=1726751532; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=9cdf4pudFoRkQ8n3oUh3m+dYAFLFowGqEqCOMSUTGXc=; b=hUCPCBp8CcAhqpt00E5CQ/AOST2WC9m2EH7X2fWGeCpXQECaPmb4NFq9frJduOVL8Q lssvFsycH/Qmlcs9pVOqZKrXaYFEQNfZPmqLzBaKSKEnBVTgcPtF67Leg0zwKbdnFqZp FDex8mFVejzi5L2imJwDhn2obcYTwdC0G1sDa6Q/GHbeITyVV3r/HKSaTF8DNE4mFnvP SywrJDxxwLq7IiCm+x6ibyWF2mn3v0keLGQuXlHJAQk4b40/3hn2gMtGcTEX5CV/5Sh0 86BFFcydl5UDUembwWUsXoQIsqAiOyc7tiVAptj6Q52GWZx53ZUWAb3ApKgwlotnnHcO /3jg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726146732; x=1726751532; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=9cdf4pudFoRkQ8n3oUh3m+dYAFLFowGqEqCOMSUTGXc=; b=Gs+jmikUoTOgNjhWIyhJVf+/T2QQaladjPaInFLHvCTCZRxaRp7wzozEESFvZ8zLQR biRPu02psakbz1teWFnNQlH2fNdxuzyllaZyz0scTd8OWyP6DlZdLuhDjeWpN7dcWGiT Sbn+wcnMPEQ9QfOnjxs4dXdNPkY5dtvHZ3CK+4jpQtQe60Pu5Xwi79Rg1yQimjMBnxIk 15JO6sroxcdGum4aEZcoqhl7vPIEZNG6zLxDpypwKS/mHMtXpfW1QaYyLFXk00GLntq8 sDbUoc2ea7In29GtdRDWvVl7gRCChaag5Af6ShWsf6WiooYB9tRxs2uO0XUL688RDmzz oH4g== X-Forwarded-Encrypted: i=1; AJvYcCXlg1wCaixfR0L5OrMgx6RbNzX/zX3mpy/DduGUIpXOaweGNT7LCCfbUOFG9fsZ/qfIM7iTRYDFCeBKjcQC@lists.postgresql.org X-Gm-Message-State: AOJu0Yypn9Gk4V0npUskPVoZRtmHsF0dNH947sPKw4FzdCjjg1PYuuOR LQG5iLbBi+K4a3WeqUBkokJy/MKz3pW0cxyi9iE9bg0WBRNoVlj1R2UcgBRZUI8eEulYU/qQXEK EQi2bLQf1HKznteZx2WuhB9N2CnY= X-Google-Smtp-Source: AGHT+IG3w5Xd5T0UY2otuQr00hHB9QIqEshkSJ6fSX2FPoi+/61F9+OUeDEBH3xO5Nh1fMi9JOUXeTdAxEVUW3c+tdA= X-Received: by 2002:a05:6820:178b:b0:5e1:ba69:1646 with SMTP id 006d021491bc7-5e201419ebfmr1369248eaf.4.1726146731652; Thu, 12 Sep 2024 06:12:11 -0700 (PDT) MIME-Version: 1.0 References: <3952715.1726115805@sss.pgh.pa.us> In-Reply-To: From: Dominique Devienne Date: Thu, 12 Sep 2024 15:11:59 +0200 Message-ID: Subject: Re: Effects of REVOKE SELECT ON ALL TABLES IN SCHEMA pg_catalog FROM PUBLIC To: Greg Sabino Mullane Cc: Andreas Joseph Krogh , Tom Lane , pgsql-general@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Sep 12, 2024 at 3:06=E2=80=AFPM Greg Sabino Mullane wrote: > (Also note that determining if a database or user exists does not even re= quire a successful login to the cluster.) Hi. How so? I was not aware of such possibilities. Can you please give pointers (docs, examples) of this? Thanks, --DD