Re: [SQL] Hide schemas and tables

2004-12-13 Thread John DeSoi
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

Re: [SQL] Hide schemas and tables

2004-12-13 Thread Richard Huxton
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 rel

[SQL] Hide schemas and tables

2004-12-13 Thread Markus Schaber
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 s