Re: Hide schemas and tables - Mailing list pgsql-sql

From Richard Huxton
Subject Re: Hide schemas and tables
Date
Msg-id 41BD96C2.20209@archonet.com
Whole thread Raw
In response to Hide schemas and tables  (Markus Schaber <schabios@logi-track.com>)
List 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


pgsql-sql by date:

Previous
From: John DeSoi
Date:
Subject: Re: Hide schemas and tables
Next
From: Richard Huxton
Date:
Subject: Re: mysql set datatype