Skip site navigation (1) Skip section navigation (2)

Everyone can see tables?

From: Richard Hayward <richard(at)tortoise(dot)demon(dot)co(dot)uk>
To: pgsql-novice(at)postgresql(dot)org
Subject: Everyone can see tables?
Date: 2004-04-07 21:02:40
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
From my reading of previous posts here, and a bit of experimentation,
I have concluded that if user A creates a database, they cannot
prevent user B from being able to see all its tables and other

All A can do is not grant B the right to select from his tables.
B can not only see the tables, but see their structure. The same goes
for views, B can see the code behind views owned by A. I assume the
same will hold for functions.

Please somebody tell me I'm wrong about this!

I want to set up a multi-database, multi-user installation, where
users cant see metadata that is none of their business.



pgsql-novice by date

Next:From: Ray NassarDate: 2004-04-07 21:52:55
Subject: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
Previous:From: Kevin LohkaDate: 2004-04-07 20:14:24
Subject: Help with Select Statement

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group