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 79D783A6153 for ; Mon, 13 Dec 2004 13:19:08 +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 07278-01 for ; Mon, 13 Dec 2004 13:19:02 +0000 (GMT) Received: from anchor-post-32.mail.demon.net (anchor-post-32.mail.demon.net [194.217.242.90]) by svr1.postgresql.org (Postfix) with ESMTP id 37D3E3A6145 for ; Mon, 13 Dec 2004 13:19:04 +0000 (GMT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-32.mail.demon.net with esmtp (Exim 4.42) id 1Cdq6R-000OwV-7k; Mon, 13 Dec 2004 13:19:03 +0000 Received: from [192.168.1.17] (client17.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 7D44C16357; Mon, 13 Dec 2004 13:19:01 +0000 (GMT) Message-ID: <41BD96C2.20209@archonet.com> Date: Mon, 13 Dec 2004 13:18:58 +0000 From: Richard Huxton User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Markus Schaber Cc: PostgreSQL SQL Subject: Re: Hide schemas and tables References: <20041213112517.41194e02@kingfisher.intern.logi-track.com> In-Reply-To: <20041213112517.41194e02@kingfisher.intern.logi-track.com> Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.122 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200412/82 X-Sequence-Number: 19702 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