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: | 0hq870hq3psarv6h9occnc0n7cj54su49a@4ax.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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
objects.
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.
regards
Richard
From | Date | Subject | |
---|---|---|---|
Next Message | Ray Nassar | 2004-04-07 21:52:55 | Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. |
Previous Message | Kevin Lohka | 2004-04-07 20:14:24 | Help with Select Statement |