Horton
Menu

Re: PostgreSQL

Laurenz Albe <laurenz.albe@cybertec.at>

View thread
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Joseph Kennedy <joseph.kennedy.486@gmail.com>, Stephen Frost <sfrost@snowman.net>
Cc: Giovanni Biscontini <biscontini.g@es2000.it>, pgsql-general@postgresql.org
Date: 2023-02-09T15:42:05Z
Lists: 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