Re: Visibility of objects in other schema's

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Fred Vos <fred(dot)vos(at)uvt(dot)nl>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Visibility of objects in other schema's
Date: 2003-10-27 16:19:06
Message-ID: 29826.1067271546@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Fred Vos <fred(dot)vos(at)uvt(dot)nl> writes:
> Since version 7.3 of PostgreSQL it's possible to create schema's. The
> User's Guide (paragraph 2.8.4) says that it is not possible to view
> objects from a schema you do not own:

> "By default, users cannot see the objects in schemas they do not own."

Poor choice of verb, I think ... it should say "cannot access the objects".

> Is it considered a problem?

No, it isn't. The \d commands rely only on being able to read the
system catalogs, which is a facility we do not intend to eliminate.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message pginfo 2003-10-27 17:21:40 another pg database corruption?
Previous Message scott.marlowe 2003-10-27 14:59:21 Re: device full ---> postgres will not start