Skip site navigation (1) Skip section navigation (2)

Restrictions for system tables

From: msz(at)mikrobit(dot)pl
To: pgsql-admin(at)postgresql(dot)org
Subject: Restrictions for system tables
Date: 2004-09-16 14:14:43
Message-ID: 1095344083.41499fd3d6d27@poczta.mbnet.pl (view raw or flat)
Thread:
Lists: pgsql-admin
Hi I have many databases in Postgresql and I want to have one user who can
connect only to one database but now if he querying pg_database (select * from
pg_database) he gets list of all databases in my postgres.
Is there any chanse to restrict access to pg_database, which gives in result of
querying pg_database only database which is owned by my restricted user?

Responses

pgsql-admin by date

Next:From: Chester KustarzDate: 2004-09-16 15:32:02
Subject: Re: VACUUM FULL achieves nothing / Postgres 7.3.2 + RedHat
Previous:From: Lic. Guillermo GonzálezDate: 2004-09-16 14:09:24
Subject: connections manager

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group