Re: system catalog

From: Oleg Samoylov <olleg(at)telecom(dot)mipt(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: system catalog
Date: 2003-02-21 08:36:14
Message-ID: 3E55E4FE.3080805@telecom.mipt.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2003-02-21 08:39:27 Re: 7.3.1 takes long time to vacuum table?
Previous Message Nigel J. Andrews 2003-02-21 08:11:14 Re: Backend often crashing