| From: | Sabyasachi Mukherjee <mukherjee(dot)sabyasachi(at)outlook(dot)com> |
|---|---|
| To: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Question about permissions in the Schema |
| Date: | 2025-06-03 11:44:41 |
| Message-ID: | PAXP194MB1230AFF50B791AD42BAF6EFE8C6DA@PAXP194MB1230.EURP194.PROD.OUTLOOK.COM |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hello,
I have a database with 5 different schemas. Each schema has the same set of tables, but the data is different.
I have created one user to access the data in the tables from one schema only.
The user can access the data from the target schema. For all other schemas it get a permission error except one.
I have specifically run the Revoke command for the schema but still the user can access the data from that schema. I have run the command in PGAdmin. Also DBBeaver does not any permission for the objects in the leaking schema for the user.
What could be wrong and how should I fix it.
I am running PG 17 on Linux.
Thanks & Regards
Sabyasachi Mukherjee
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Holger Jakobs | 2025-06-03 12:02:06 | Re: Question about permissions in the Schema |
| Previous Message | Motog Plus | 2025-06-02 12:55:32 | Re: Seeking Suggestions for Best Practices: Archiving and Migrating Historical Data in PostgreSQL |