PostgreSQL - hiding tables from user [duplicate]

Question

I wonder if there is a possibility to hide tables from a certain user, not just revoking access to them.

Basically what needs to be done is to grant a user read-only access to the DB, but hide some tables from him.

I tried to revoke all privileges from schema public but to no avail.

Related: How to prevent a login from 'listing' a table or view definition in PostgreSQL? or PostgreSQL 9.5: Permission to deny functions body — Abelisto
– Abelisto, Commented Jul 10, 2017 at 20:18

Kristo Mägi · Accepted Answer · 2017-07-10 17:20:17Z

2

So far you can not hide Postgres System Catalogs. Meaning you can not hide metadata.

The user can still see the structure, but can not access them if not granted access.

answered Jul 10, 2017 at 17:20

Kristo Mägi

1,70413 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Athanasios Emmanouilidis · Accepted Answer · 2017-07-10 17:26:14Z

0

If you want to grant specific permissions to specific users you can use VIEWS.

answered Jul 10, 2017 at 17:26

2,1543 gold badges19 silver badges30 bronze badges