Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

PostgreSQL - hiding tables from user [duplicate]

Tags:

postgresql

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.

like image 229
RKh Avatar asked Sep 13 '25 14:09

RKh


1 Answers

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.

like image 175
Kristo Mägi Avatar answered Sep 16 '25 22:09

Kristo Mägi