Re: system catalog - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: system catalog
Date
Msg-id Pine.LNX.4.44.0302220306270.2067-100000@peter.localdomain
Whole thread Raw
In response to system catalog  (Jose Antonio Martinez <lfbbes@yahoo.es>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: How to update rows from a cursor in PostgreSQL
Next
From: Peter Eisentraut
Date:
Subject: Re: regexp question