| Lists: | pgsql-sql |
|---|
| From: | Markus Schaber <schabios(at)logi-track(dot)com> |
|---|---|
| To: | PostgreSQL SQL <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Hide schemas and tables |
| Date: | 2004-12-13 10:25:17 |
| Message-ID: | 20041213112517.41194e02@kingfisher.intern.logi-track.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-sql |
Hello,
Is there any way to hide schemas and relations a user does not have
access privileges for?
I suspect that the client (in this case, unavoidably excel via OLAP and
ODBC) gets this information via querying meta tables, so there is no way
to protect foreign schemas and relations from beeing seen.
Thanks,
Markus
--
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 zürich
phone +41-43-888 62 52 | fax +41-43-888 62 53
mailto:schabios(at)logi-track(dot)com | www.logi-track.com
| From: | John DeSoi <desoi(at)pgedit(dot)com> |
|---|---|
| To: | Markus Schaber <schabios(at)logi-track(dot)com> |
| Cc: | PostgreSQL SQL <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Hide schemas and tables |
| Date: | 2004-12-13 13:16:48 |
| Message-ID: | 3E66B0AD-4D09-11D9-A31C-000A95B03262@pgedit.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-sql |
On Dec 13, 2004, at 5:25 AM, Markus Schaber wrote:
> Is there any way to hide schemas and relations a user does not have
> access privileges for?
>
> I suspect that the client (in this case, unavoidably excel via OLAP and
> ODBC) gets this information via querying meta tables, so there is no
> way
> to protect foreign schemas and relations from beeing seen.
Yes, you are correct. I'm not aware of any way to hide this information.
Best,
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Markus Schaber <schabios(at)logi-track(dot)com> |
| Cc: | PostgreSQL SQL <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Hide schemas and tables |
| Date: | 2004-12-13 13:18:58 |
| Message-ID: | 41BD96C2.20209@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-sql |
Markus Schaber wrote:
> Hello,
>
> Is there any way to hide schemas and relations a user does not have
> access privileges for?
>
> I suspect that the client (in this case, unavoidably excel via OLAP and
> ODBC) gets this information via querying meta tables, so there is no way
> to protect foreign schemas and relations from beeing seen.
Obviously, everyone needs access to the system tables and at present
there is no system in place to restrict access to viewing all their
contents.
--
Richard Huxton
Archonet Ltd