pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedHide schemas and tables
3+ messages / 3 participants
[nested] [flat]
* Hide schemas and tables
@ 2004-12-13 10:25 Markus Schaber <schabios@logi-track.com>
0 siblings, 2 replies; 3+ messages in thread
From: Markus Schaber @ 2004-12-13 10:25 UTC (permalink / raw)
To: 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@logi-track.com | www.logi-track.com
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Hide schemas and tables
@ 2004-12-13 13:16 John DeSoi <desoi@pgedit.com>
parent: Markus Schaber <schabios@logi-track.com>
1 sibling, 0 replies; 3+ messages in thread
From: John DeSoi @ 2004-12-13 13:16 UTC (permalink / raw)
To: Markus Schaber <schabios@logi-track.com>; +Cc: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Hide schemas and tables
@ 2004-12-13 13:18 Richard Huxton <dev@archonet.com>
parent: Markus Schaber <schabios@logi-track.com>
1 sibling, 0 replies; 3+ messages in thread
From: Richard Huxton @ 2004-12-13 13:18 UTC (permalink / raw)
To: Markus Schaber <schabios@logi-track.com>; +Cc: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-12-13 13:18 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-12-13 10:25 Hide schemas and tables Markus Schaber <schabios@logi-track.com>
2004-12-13 13:16 ` John DeSoi <desoi@pgedit.com>
2004-12-13 13:18 ` Richard Huxton <dev@archonet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox