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 1mD4pi-00018x-Nk for pgsql-sql@arkaria.postgresql.org; Mon, 09 Aug 2021 12:56:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mD4pB-0001WZ-US for pgsql-sql@arkaria.postgresql.org; Mon, 09 Aug 2021 12:56:13 +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 1mD4pB-0001WQ-LD for pgsql-sql@lists.postgresql.org; Mon, 09 Aug 2021 12:56:13 +0000 Received: from mail-ej1-x62e.google.com ([2a00:1450:4864:20::62e]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mD4p8-0007th-JW for pgsql-sql@lists.postgresql.org; Mon, 09 Aug 2021 12:56:13 +0000 Received: by mail-ej1-x62e.google.com with SMTP id yk17so28727647ejb.11 for ; Mon, 09 Aug 2021 05:56:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=reply-to:to:from:subject:message-id:disposition-notification-to :date:user-agent:mime-version:content-transfer-encoding :content-language; bh=Gfumhez/y4ryWIZFDMd1y/Yj5MVXj7WvoCy1SyZytG4=; b=G+AAcxwQRqZL2QFrM5rdCUiKnpZbnEgmDrgHv55QIt+4PoMW0kWrdtQl38/TfbWTW/ NF91BiRfkQTTtP0IWvkBOxyb0wETYZ5uAX0Sr/xUTC8BTxvdxJobUlFfyWt1toAKF154 CMdI2PS1S188rMY2ki0M+EQ2UgyIY2c4u8yQyshx071pplNiNj7yQz/my/6GcMXvBoho 2ouEFRbpAYPVlli+tJ4SUuO/C85wOfEPX1sdCG5dR2ajZ8cMmokZ1/4VxKVNQJxZWPQR ji7n3BjYf9nbY9XmZgCVVM7ViwwgiDsa68WvYymOo8gX/rR3Y1HXad0LrS4z4SuD0qgH Dnfw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:reply-to:to:from:subject:message-id :disposition-notification-to:date:user-agent:mime-version :content-transfer-encoding:content-language; bh=Gfumhez/y4ryWIZFDMd1y/Yj5MVXj7WvoCy1SyZytG4=; b=uI3G540YjgdA1ueg9EjSDKmBaQqIPvAeRLEXeXiGVDMRHrC5Y7FPh/VoOf6Nghasgm 6XezUHBIDJZHOFGHZAQeMxF6Rh6SJhtogWjZS9wPFmJC7p8hLfaqtWhQ/Ah+XNjhBWux odM1Q//0ZCsz5Qxw7aKVUvjN1Dm1f31xmkp/4Eaypc0Ict3l3D++40ZI+ZRZJRowiUjO OXKSTQVyiAsayWTqBrlEfIxV3BZheACDG/s69qQRpWTjtNJlER8kWBNC2n2kqEYYFY3a Z458gtWbzg92HlqgJ59N2OGFBgdvsQNTcAn4l48KJXs11hqN8uLDA9MQ+6FcUesDXDch F8nw== X-Gm-Message-State: AOAM53026oLWida5dcilLyONvy72L+WSIT0YTuOSIZGBWS3FuqCQ3Ors foteaL/tyIiugE/39ZosQd3s/KNeV2A= X-Google-Smtp-Source: ABdhPJwYZyepP5h+c/5mcvxnLq0i60zwadea4BUDfqENLoclFpaxV3fc7ADnJ4v3KxLscp0iZIQfQw== X-Received: by 2002:a17:906:5384:: with SMTP id g4mr22703881ejo.27.1628513769526; Mon, 09 Aug 2021 05:56:09 -0700 (PDT) Received: from [10.0.0.4] ([41.77.19.28]) by smtp.gmail.com with ESMTPSA id r2sm3612494edv.78.2021.08.09.05.56.07 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 09 Aug 2021 05:56:08 -0700 (PDT) Reply-To: intmail01@gmail.com To: pgsql-sql@lists.postgresql.org From: "intmail01@gmail.com" Subject: Hide some tables Message-ID: <2a4f55f7-b8fb-4937-9136-c7e35de63f79@gmail.com> Disposition-Notification-To: "intmail01@gmail.com" Date: Mon, 9 Aug 2021 12:57:01 +0000 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.11.0 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Content-Language: fr List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, There are some operators who enters data in my database with just one table. Others tables are updated by triggers, these tables contains result of calculation. How to do to hide these tables because I do not want that operators read them ? On help documentation it is said that I can not block SELECT privilege because it is required for UPDATE. Thanks