Horton
Menu

Re: PostgreSQL

Stephen Frost <sfrost@snowman.net>

View thread
From: Stephen Frost <sfrost@snowman.net>
To: Joseph Kennedy <joseph.kennedy.486@gmail.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>, Giovanni Biscontini <biscontini.g@es2000.it>, pgsql-general@postgresql.org
Date: 2023-02-08T00:35:58Z
Lists: pgsql-general 
Greetings,

* Joseph Kennedy (joseph.kennedy.486@gmail.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