Re: Browse database , schema - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Browse database , schema
Date
Msg-id 20060716122523.GA28622@winnie.fuhr.org
Whole thread Raw
In response to Browse database , schema  (qnick@spec.net.pl)
List pgsql-general
On Sat, Jul 15, 2006 at 04:04:50AM -0700, qnick@spec.net.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

pgsql-general by date:

Previous
From: Christian Kratzer
Date:
Subject: Re: Scaleable DB structure for counters...
Next
From: Adam Witney
Date:
Subject: Re: I have a questions, can you help-me ?