Skip site navigation (1) Skip section navigation (2)

Re: Hide schemas and tables

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 (view raw or flat)
Thread:
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

In response to

pgsql-sql by date

Next:From: Richard HuxtonDate: 2004-12-13 13:25:48
Subject: Re: mysql set datatype
Previous:From: John DeSoiDate: 2004-12-13 13:16:48
Subject: Re: Hide schemas and tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group