Re: Browse database , schema

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: qnick(at)spec(dot)net(dot)pl
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Browse database , schema
Date: 2006-07-16 12:25:23
Message-ID: 20060716122523.GA28622@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Jul 15, 2006 at 04:04:50AM -0700, qnick(at)spec(dot)net(dot)pl wrote:
> I have a question about rights to browse a database and a schema's
> structure. Is this normal that user who isn't have any permission as
> select to same db or scheme may explore it and see tables (table's fields
> etc.) ?

Users who can connect to a database can query that database's system
catalogs.

> How prohibit that ? Thanks

Don't allow users to connect to databases whose structures you don't
want the users to browse.

--
Michael Fuhr

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adam Witney 2006-07-16 16:36:20 Re: I have a questions, can you help-me ?
Previous Message Christian Kratzer 2006-07-16 11:38:56 Re: Scaleable DB structure for counters...