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 1pPYRP-0004F5-G5 for pgsql-general@arkaria.postgresql.org; Wed, 08 Feb 2023 00:36:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pPYRO-0001M2-4Z for pgsql-general@arkaria.postgresql.org; Wed, 08 Feb 2023 00:36:02 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pPYRN-0001Lt-Pj for pgsql-general@lists.postgresql.org; Wed, 08 Feb 2023 00:36:01 +0000 Received: from tamriel.snowman.net ([2001:470:e38f::11]) by makus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pPYRL-0008TG-61 for pgsql-general@postgresql.org; Wed, 08 Feb 2023 00:36:00 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 438FD5F7BC; Tue, 7 Feb 2023 19:35:58 -0500 (EST) Date: Tue, 7 Feb 2023 19:35:58 -0500 From: Stephen Frost To: Joseph Kennedy Cc: Laurenz Albe , Giovanni Biscontini , pgsql-general@postgresql.org Subject: Re: PostgreSQL Message-ID: References: <8C7CE513-7187-428E-81C2-508C85812B54@gmail.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="Qt2Nf5rSpl9O/JHr" Content-Disposition: inline In-Reply-To: <8C7CE513-7187-428E-81C2-508C85812B54@gmail.com> User-Agent: Mutt/2.1.4 (2021-12-11) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Qt2Nf5rSpl9O/JHr Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings, * Joseph Kennedy (joseph.kennedy.486@gmail.com) wrote: > Thank you Laurenz, I just wanted to make sure.=20 >=20 > Do you know any alternative solution to RLS ? =2E.. to do what? If you want to limit the set of rows that a given user can see, RLS is how to do that. If you want to limit the schemas or tables that a user can see, that isn't possible in PG today (though there was some interest a while back in making that work via RLS on the catalogs which you might be able to find). Thanks, Stephen --Qt2Nf5rSpl9O/JHr Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEwf6gbxKhD863zrx/7WyKOINHZFUFAmPi7moACgkQ7WyKOINH ZFXp2Q/6Ag65uMseMzelbug7MnnUkcOXREEtBZ7wpJUc1qW40iNtNnGN0ZUqUCCY 03ZVt+by3hvrJLWxxiL9UKv+Iw++A0xxVm2W0Wdj3wDJoUocu7CQk+NIYtvnJ2VA Pl0k66y1wqozj4Z7JIfDtfxbz254bOk1FAJxV2J7ngNuwnUDIuNdybgPvsZK3Vtb l7v8wMjCo9p88bdULJqkv5LMAPgwQ/5DIMm5lLZh0UrAfH6zHoQYPGGCUiDkGBBe 8KtSA44mdLOhY6rN3mfY6A9IUwpHQuaiTkK47GnhxNtNdMpmBjDqo6oPapfyhkI9 NRqlktLNOPPFfCLvGK/n78ulG1KOgOpFbAc+CSUjWeQB+Yxx14Wan8ekJOeRbcaN tFeNTPNiA2m7LJkgzGPKqPGCmSHC10z/06k8Um9YmbGn50t3rkBNLSypg0QtnyQ3 HSUrNJp0cHjT6rzIjBIseD+g+dUdinLpdRff2rO6BpnEwXgIWBAOX4auPAlh56ly qIzXt+uW8r2As0fBO9kQ+DPBEqq+dIA5UzeV7alSUKYOJMPeZOAdV50T6dB6lY0I MA61f1VgCQJY4ZJVUkoQSw8lwXb1oWdYpz0QOOnXpTBr7uzVSeVK0wXk6wdJ8bVx RoBPIoXGD4RwijpsBm7L2WJJwTHay12PYjKtasz1jRWGGpcWBpY= =0RWG -----END PGP SIGNATURE----- --Qt2Nf5rSpl9O/JHr--