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

Re: problems with user rights

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Zouari Fourat <fourat(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: problems with user rights
Date: 2005-03-30 13:04:00
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
> i've just added a new user called xxx :
> create user xxx with password zzz;
> now am creating it's database :
> create database db_xxx with owner xxx;
> it works fine althought when logging with the user xxx i can still
> view other databases contents  especially pg_catalog schems.
> is it the right way to add a user ? am i wrong ?
> i dont want to let my new user view the others databases on the server.

Viewing the information in the system catalogs is open to all users. 
There is not a way to hide it unless you build an interface on top of 
PostgreSQL that limits the queries the user can execute.

John DeSoi, Ph.D.
Power Tools for PostgreSQL

In response to


pgsql-admin by date

Next:From: Marco CarvalhoDate: 2005-03-30 14:51:37
Subject: multiple servers updating from/to one
Previous:From: Zouari FouratDate: 2005-03-30 08:43:34
Subject: Re: problems with user rights

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