PostgreSQL

From: Joseph Kennedy <joseph(dot)kennedy(dot)486(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PostgreSQL
Date: 2023-02-07 11:02:21
Message-ID: A39C6073-B097-4403-A9DB-05D039047C4A@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I would like restrict access to sensitive or restricted information for some users (eg. hide data of one or more clients for 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rinat Shigapov 2023-02-07 11:08:26 Re: Too coarse predicate locks granularity for B+ tree indexes
Previous Message Sebastien Flaesch 2023-02-07 10:43:06 Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column