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: 2EE9A7E0-A11C-11D9-A2E3-000A95B03262@pgedit.com (view raw or flat)
Thread:
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.
http://pgedit.com/
Power Tools for PostgreSQL


In response to

Responses

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-2014 The PostgreSQL Global Development Group