Postgres Pro
Downloads
Home   >   mailing lists

Question about permissions in the Schema - Mailing list pgsql-admin

From Sabyasachi Mukherjee
Subject Question about permissions in the Schema
Date
Msg-id PAXP194MB1230AFF50B791AD42BAF6EFE8C6DA@PAXP194MB1230.EURP194.PROD.OUTLOOK.COM
Whole thread Raw
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Motog Plus
Date:
Subject: Re: Seeking Suggestions for Best Practices: Archiving and Migrating Historical Data in PostgreSQL
Next
From: "Radoulov, Dimitre"
Date:
Subject: vacuumlo Permission Discrepancy Between Prod and Dev on AWS Aurora PostgreSQL