Thread: Hide schemas and tables

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

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

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