Re: PostgreSQL - Mailing list pgsql-general

From Laurenz Albe
Subject Re: PostgreSQL
Date
Msg-id 2eef5146f9836742de02d9db5cbe6cc8a4e3827d.camel@cybertec.at
Whole thread Raw
In response to Re: PostgreSQL  (Joseph Kennedy <joseph.kennedy.486@gmail.com>)
Responses Re: PostgreSQL  (Joseph Kennedy <joseph.kennedy.486@gmail.com>)
List pgsql-general
On Thu, 2023-02-09 at 09:54 +0100, Joseph Kennedy wrote:
> As I wtote, 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).
>
> My question is: do you know some other solution to do that ? 

It is easy to hide data from users: use permissions or row level security.

It is impossible to hide metadata from users, but we don't consider that a problem.

If you want that, use a database or a database cluster per user.

Yours,
Laurenz Albe



pgsql-general by date:

Previous
From: Dominique Devienne
Date:
Subject: WHERE col = ANY($1) extended to 2 or more columns?
Next
From: Kiriakos Georgiou
Date:
Subject: Concurrency issue with DROP INDEX CONCURRENTLY