cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED
Silver 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

Tags (1)
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.

2 REPLIES
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.

Silver Adventurer

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

thanks!!!