PostgreSQL - Mailing list pgsql-general

From Joseph Kennedy
Subject PostgreSQL
Date
Msg-id A39C6073-B097-4403-A9DB-05D039047C4A@gmail.com
Whole thread Raw
Responses Re: PostgreSQL
Re: PostgreSQL
Re: PostgreSQL
List pgsql-general
I would like restrict access to sensitive or restricted information for some users (eg. hide data of one or more
clientsfor some database users). 

PostgreSQL allows to create security policy as Row-Level Security, policies based on the querying user.


Are there any other alternatives to RLS, are there any better solutions??

What are  the advantages and disadvantages of RLS?

How much RLS will cause a decrease in database performance?

JK





pgsql-general by date:

Previous
From: Sebastien Flaesch
Date:
Subject: Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column
Next
From: Rinat Shigapov
Date:
Subject: Re: Too coarse predicate locks granularity for B+ tree indexes