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 1pMU3X-0003ds-1F for pgsql-general@arkaria.postgresql.org; Mon, 30 Jan 2023 13:18:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pMU3V-000094-VO for pgsql-general@arkaria.postgresql.org; Mon, 30 Jan 2023 13:18:41 +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 1pMU3V-00008A-KW for pgsql-general@lists.postgresql.org; Mon, 30 Jan 2023 13:18:41 +0000 Received: from mail-qt1-x82f.google.com ([2607:f8b0:4864:20::82f]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pMU3T-0000nO-Iu for pgsql-general@lists.postgresql.org; Mon, 30 Jan 2023 13:18:41 +0000 Received: by mail-qt1-x82f.google.com with SMTP id j9so9895085qtv.4 for ; Mon, 30 Jan 2023 05:18:39 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=zhyeX7SxjD4bCuFW5KumgTsIxN+uerL/XepWogBHWP4=; b=ReYqbM8AugKoAkDUEsJXHXrTomPlabm5FSXP7FbG7Mi/p/+Lb8Fx8uq32u9snaODwv PrY0qxouHHT1Sapsxk90gx6EVHkZQe77o78KkBhOugNM89faqwKZCCexI/04dUG18M5r wsi4jvR/6rFI9QqGB155jcY/8JT8fCJppooJ5A0RUGLSIlvbe1ustCxJj+ku0Yl8Op3Z YP71a/22CvzXn0wBsjvbRNCBEvlus7LGs1vpB0bT7N/PiPb3lkxepQXzQSLTOAUzprqN 67rgnKAptTNVWpHxP5ztDuMBCp+GloHNDX8nZAyQLEgV6+gLBghmqXkZuUyogEvvAmzP hDag== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=zhyeX7SxjD4bCuFW5KumgTsIxN+uerL/XepWogBHWP4=; b=UQtybH6FvsDgHvQzQ0/uFpjBUi/JO9KHglHECRcyL9S/VuApmW2gFi3+yQy/Xqg7+L SVALY0JaGlC5VGHwNUkUw6UwQN8TVrTJexfbpoW9gP9dx1uRma3n4U0AO6ZmHgSdqfha 7DOtLhUI2n9JKXjkip8Oa2Ymy1nMqALTJQCr6jk4PZxZuM8q+uszNNrL8EWqlsnObs+N YLWFMT/TcUX3Gfhwg+Pf6glc8+tqA3lFxykLbDYafISonxKqfoOQe/HajmMhJnb9Tb+w Sbho3ZjxAJthIIuXFdyuG9fwNSmTQ2Cs1gbFZMtDb3rxmYpgmmAm3Q6BNT2KQR76mBuY yOwg== X-Gm-Message-State: AFqh2kqoRSPTl7F6thgngkCml1SfQUdE/wfCg0lDgGaMhn/2kMI8swn8 8JmoyXcOxNxKzvI4Sd9BaGbAg4tpFSw= X-Google-Smtp-Source: AMrXdXtcLiO/JGsTcik9nBzH5aeSbJ0AA0ljd7oif45JGt+TLAHASSjOQ3CXpSmp4up8tg7g5M6wog== X-Received: by 2002:ac8:4e09:0:b0:39c:da21:f1a2 with SMTP id c9-20020ac84e09000000b0039cda21f1a2mr63066706qtw.3.1675084716976; Mon, 30 Jan 2023 05:18:36 -0800 (PST) Received: from [192.168.1.66] (108-250-206-84.lightspeed.nworla.sbcglobal.net. [108.250.206.84]) by smtp.googlemail.com with ESMTPSA id z22-20020ac87cb6000000b003ad373d04b6sm6415338qtv.59.2023.01.30.05.18.36 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 30 Jan 2023 05:18:36 -0800 (PST) Message-ID: Date: Mon, 30 Jan 2023 07:18:35 -0600 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.4.2 Subject: Re: How to control pg_catalog results for each users? Content-Language: en-US To: pgsql-general@lists.postgresql.org References: <32b68caa-8731-8952-bad5-462566760809@swc.toshiba.co.jp> <564d8a38d11cee5f490cc0a40baf322fc884ed8a.camel@cybertec.at> From: Ron In-Reply-To: <564d8a38d11cee5f490cc0a40baf322fc884ed8a.camel@cybertec.at> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 1/30/23 02:41, Laurenz Albe wrote: > On Mon, 2023-01-30 at 14:00 +0900, hirose shigeo(廣瀬 繁雄 □SWC○ACT) wrote: >> all users can get the all of table name , table structure and other >> 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. Your description sounds a whole lot like PostgreSQL's row level security. -- Born in Arizona, moved to Babylonia.