| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Joseph Kennedy <joseph(dot)kennedy(dot)486(at)gmail(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net> |
| Cc: | Giovanni Biscontini <biscontini(dot)g(at)es2000(dot)it>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL |
| Date: | 2023-02-09 15:42:05 |
| Message-ID: | 2eef5146f9836742de02d9db5cbe6cc8a4e3827d.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kiriakos Georgiou | 2023-02-09 15:45:21 | Concurrency issue with DROP INDEX CONCURRENTLY |
| Previous Message | Dominique Devienne | 2023-02-09 15:41:41 | WHERE col = ANY($1) extended to 2 or more columns? |