X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 9E87A3A5FD0
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 13 Dec 2004 10:25:28 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 51269-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 13 Dec 2004 10:25:23 +0000 (GMT)
Received: from mail.logi-track.com (burro.logi-track.com [213.239.193.212])
	by svr1.postgresql.org (Postfix) with ESMTP id 01E1E3A5F9C
	for <pgsql-sql@postgresql.org>; Mon, 13 Dec 2004 10:25:24 +0000 (GMT)
Received: from kingfisher.intern.logi-track.com (J0118.j.pppool.de
	[85.74.1.24])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by mail.logi-track.com (Postfix) with ESMTP id 46FE53066A;
	Mon, 13 Dec 2004 11:25:22 +0100 (CET)
Received: from kingfisher.intern.logi-track.com (localhost [127.0.0.1])
	by kingfisher.intern.logi-track.com (Postfix) with SMTP id 0E0BAAB2B4;
	Mon, 13 Dec 2004 11:25:17 +0100 (CET)
Date: Mon, 13 Dec 2004 11:25:17 +0100
From: Markus Schaber <schabios@logi-track.com>
To: PostgreSQL SQL <pgsql-sql@postgresql.org>
Subject: Hide schemas and tables
Message-ID: <20041213112517.41194e02@kingfisher.intern.logi-track.com>
Organization: logi-track ag, =?ISO-8859-15?Q?z=FCrich?=
X-Mailer: Sylpheed-Claws 0.9.12b (GTK+ 1.2.10; i386-pc-linux-gnu)
X-Face: Nx5T&>Nj$VrVPv}sC3IL&)TqHHOKCz/|)R$i"*r@w0{*I6w;
	UNU_hdl1J4NI_m{IMztq=>cmM}1gCLbAF+9\#CGkG8}Y{x%SuQ>1#t:;
	Z(|\qdd[i]HStki~#w1$TPF}:0w-7"S\Ev|_a$K<GcL?@F\BY,ut6tC0P<$eV&ypzvlZ~R00!A
X-PGP-Key: http://schabi.de/pubkey.asc
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200412/77
X-Sequence-Number: 19697

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
--=20
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 z=FCrich
phone +41-43-888 62 52 | fax +41-43-888 62 53
mailto:schabios@logi-track.com | www.logi-track.com