Visibility of objects in other schema's

From: Fred Vos <fred(dot)vos(at)uvt(dot)nl>
To: pgsql-admin(at)postgresql(dot)org
Subject: Visibility of objects in other schema's
Date: 2003-10-22 17:46:11
Message-ID: 3F96C263.5090808@uvt.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

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."

I'm using PostgreSQL 7.3.4 under Linux. As the administrator I created
two schema's for two users:

create schema vosf authorization vosf;
create schema snefru authorization snefru;

If I logon to the database with psql as user vosf and create a table, it
is created under schema vosf. That's good. If I logon to the same
database with psql as user snefru and issue:

\d vosf.*

I can see all tables within the vosf schema. Paragraph 2.8.4 says I
should not. I cannot do selects from these tables, but I think seeing
what tables a user has created and which columns these have is wrong. I
want to use a single database on a single server, but this visibility
issue keeps me using multiple databases. Is it considered a problem? If
so, is it a known problem? Not subscribed anymore to any PostgreSQL
list, I searched the archives, but did not find a similar question.

Thanks for any help. PostgreSQL is a great database.

Fred

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephen J. Thompson 2003-10-22 18:55:14 Multi-Language server
Previous Message David Wagoner 2003-10-22 17:27:58 Re: Need PGSQL ODBC Driver for Solaris