Обсуждение: system catalog

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.



___________________________________________________
Yahoo! Móviles
Personaliza tu móvil con tu logo y melodía favorito
en http://moviles.yahoo.es

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

Jose Antonio Martinez writes:

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

Revoke the permissions.

--
Peter Eisentraut   peter_e@gmx.net