<div>
<div class="content wysiwyg-content">
I am familiar with permissions in Sybase, but I wonder if there is a way to HIDE tables and views from a user in SQLAnywhere.<br />
<br />
I note that if somebody uses an ODBC connection say in Excel, that user can see all of the tables, and views - whether I have granted them permission or not on any particular table.
</div>
</div>


I am familiar with permissions in Sybase, but I wonder if there is a way to HIDE tables and views from a user in SQLAnywhere.

I note that if somebody uses an ODBC connection say in Excel, that user can see all of the tables, and views - whether I have granted them permission or not on any particular table.

Hiding tables or views in SQLAnyhwere 11.0.1

Small Business Server (SBS) is a line of server operating systems targeted at small businesses by bundling the operating system with a number of other Microsoft products that would normally need to be purchased or licensed separately. The most notable inclusions are Exchange, SQL Server, SharePoint and ISA/TMG (Microsoft's firewall and proxy server).

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.