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 1pMPjn-0008Bt-VY for pgsql-general@arkaria.postgresql.org; Mon, 30 Jan 2023 08:42:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pMPjm-0002Yi-EG for pgsql-general@arkaria.postgresql.org; Mon, 30 Jan 2023 08:42:02 +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 1pMPjl-0002YZ-VD for pgsql-general@lists.postgresql.org; Mon, 30 Jan 2023 08:42:02 +0000 Received: from mail-ej1-x62b.google.com ([2a00:1450:4864:20::62b]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pMPjf-0006We-6Q for pgsql-general@lists.postgresql.org; Mon, 30 Jan 2023 08:42:01 +0000 Received: by mail-ej1-x62b.google.com with SMTP id mf7so10787832ejc.6 for ; Mon, 30 Jan 2023 00:41:54 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20210112.gappssmtp.com; s=20210112; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=AIng0Meb5TUGK3KPydj+VEZ9Yvsh8qE5372Y+xWVy/Q=; b=Y3FxK/ojV5SIlU9k1yRG2lkGLH8k2ag40M2Kt5Vjes9L/CVr/O9wmkJ+WVYNopx7c4 VXDk40ZMxUpnMMg5mhgA7GCEMjXL/Zlvl+Wdxm4UN/5sLlMA6MD97kJQPgpvoPmp3MDa OEfTMx1kmJbZbqFclkJJutXAUKXpQBhvgZ0H0TXNfLnQMaCxYwS7AruhZK+6vYc6t/mP YbW7mrpY1Il+ZGlrxCbPDJvvn27mfXnHcYDMPtTB3lEQyAxEMlX47qYnbjX1OTVRonJY M2osDoicHLLF8XXLrVCl8mbY4KJ3CJT2lyt8+CbOLU+akvDE/JiOv0hRsJZxL4W2dzJ7 CU0Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=AIng0Meb5TUGK3KPydj+VEZ9Yvsh8qE5372Y+xWVy/Q=; b=2u1Yz+TTalGB+plzTP/srj+Q2fXnuAaqSI3x+eLTQMUpKJzLZZo+ig5oNe3zo+VF8Z /ebALLQEaSHNfA7Eo0FsVk9/9E/7+QYedAYE0HDb9z9jLqJnDRmyojTAVln6iCIJJP7L m9kxZ6h8fE+XeZudG4N9yuMrPKXprx99FabSpyvoDyqGbDzz3AUPmhacAYsHGiLCPsHl l+JsTe6Q9nZiOmbPqwOCrj+ZLtqMaFCg5FSoRKbxDxgPXMGXMjZJTx7vrn+jSWK3l0Gm Gaa892MLW2JE8Pi0bg1rWGqJ9Z15bGtxgd/LmXIGsdMleKgKSYGg9FfF/h2sm/sljwc5 4cIQ== X-Gm-Message-State: AO0yUKWWkP0IbPZhVyj/Oke8CRugt+yvg9i68eQtWh1Mr8g6jF6VmqrH WLcr4B5/PW+ou6AJfXQ1rab/lA== X-Google-Smtp-Source: AK7set+YzLOPxvLX1MeqZ0LTJH7bg0OHv+fkV2jihNR22hANuuiKMMRj2JnX/dx7RavinqnpEBZblA== X-Received: by 2002:a17:907:b9ce:b0:88a:b6ca:7d3d with SMTP id xa14-20020a170907b9ce00b0088ab6ca7d3dmr347425ejc.8.1675068114102; Mon, 30 Jan 2023 00:41:54 -0800 (PST) Received: from dynamic-pd01.res.v6.highway.a1.net ([2001:871:5e:539:1b2c:c52a:475d:310c]) by smtp.gmail.com with ESMTPSA id u1-20020a1709064ac100b0079800b8173asm6560997ejt.158.2023.01.30.00.41.53 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 30 Jan 2023 00:41:53 -0800 (PST) Message-ID: <564d8a38d11cee5f490cc0a40baf322fc884ed8a.camel@cybertec.at> Subject: Re: How to control pg_catalog results for each users? From: Laurenz Albe To: hirose =?UTF-8?Q?shigeo=28=E5=BB=A3=E7=80=AC_=E7=B9=81=E9=9B=84_?= =?UTF-8?Q?=E2=96=A1SWC=E2=97=8BACT=29?= , pgsql-general@lists.postgresql.org Date: Mon, 30 Jan 2023 09:41:53 +0100 In-Reply-To: <32b68caa-8731-8952-bad5-462566760809@swc.toshiba.co.jp> References: <32b68caa-8731-8952-bad5-462566760809@swc.toshiba.co.jp> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.46.3 (3.46.3-1.fc37) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2023-01-30 at 14:00 +0900, hirose shigeo(=E5=BB=A3=E7=80=AC =E7=B9= =81=E9=9B=84 =E2=96=A1SWC=E2=97=8BACT) wrote: > all users can get the all of table name , table structure and other=20 > information from pg_catalog, which is considered a security problem. The belief that restricting that will improve security goes by the name of "security by obscurity", which is usually not considered robust. Yours, Laurenz Albe