Is posible restrict access for some user for tables and views in pg_catalog schema?

SOLVED
Highlighted
Gold Adventurer

Is posible restrict access for some user for tables and views in pg_catalog schema?

Hi all

I need to restrict access for some user for tables and views in pg_catalog schema, 

without this having any implication on dababase function

Is posible in EDB Postgres?

Regards

Archived Discussions


Effective March 31st, we will no longer engage on PostgresRocks.


How to engage with us further?


  • Thought Leadership: EDB Blogs

  • Tips and Tricks: Postgres Tutorials

  • Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket

  • Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
EDB Team Member

Re: Is posible restrict access for some user for tables and views in pg_catalog schema?

Hi asotolongo,

 

Unfortunately, we can't revoke the access of a user from the pg_catalog schema.

As it will always be needed for the internal workflow of the PostgreSQL cluster. (Like, statistics for query planning).

 

Hope this helps.

Regards,
Dhananjay

View solution in original post

2 REPLIES 2
Highlighted
EDB Team Member

Re: Is posible restrict access for some user for tables and views in pg_catalog schema?

Hi asotolongo,

 

Unfortunately, we can't revoke the access of a user from the pg_catalog schema.

As it will always be needed for the internal workflow of the PostgreSQL cluster. (Like, statistics for query planning).

 

Hope this helps.

Regards,
Dhananjay

View solution in original post

Highlighted
Gold Adventurer

Re: Is posible restrict access for some user for tables and views in pg_catalog schema?

thanks!!!

© 2019 EnterpriseDB Corporation. All rights reserved.   |   Privacy Policy   |  Terms of Use   |   Trademarks