Re: system catalog - Mailing list pgsql-general

From Oleg Samoylov
Subject Re: system catalog
Date
Msg-id 3E55E4FE.3080805@telecom.mipt.ru
Whole thread Raw
In response to system catalog  (Jose Antonio Martinez <lfbbes@yahoo.es>)
List pgsql-general
Jose Antonio Martinez wrote:
> an user (not superuser) of any postgresql database can
> access to pg_user, pg_database ,
> pg_stat_get_db_numbackends , ...
>
> is there any way of avoid this? i mean : only
> superuser could access to catalog and statisc views.

IMHO backend process need access to system tables for system purpose
(for planning query,etc) and it run with user permissions. So you can't
avoid this.

--
Olleg Samoylov


pgsql-general by date:

Previous
From: "Gregory Wood"
Date:
Subject: Re: Foreign Key with Constant
Next
From: Bruno Wolff III
Date:
Subject: Re: Problem with functional indexes