Re: PostgreSQL

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Joseph Kennedy <joseph(dot)kennedy(dot)486(at)gmail(dot)com>
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Giovanni Biscontini <biscontini(dot)g(at)es2000(dot)it>, pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL
Date: 2023-02-08 00:35:58
Message-ID: Y+Lubn8HhIIpTUJl@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings,

* Joseph Kennedy (joseph(dot)kennedy(dot)486(at)gmail(dot)com) wrote:
> Thank you Laurenz, I just wanted to make sure.
>
> Do you know any alternative solution to RLS ?

... 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message sunyucong@gmail.com 2023-02-08 01:07:25 Re: Need help debugging slow logical replication
Previous Message Rob Sargent 2023-02-08 00:32:52 Re: Quoting issue from ODBC