Easysoft ODBC-ODBC Bridge

Why can I see more tables in Microsoft SQL Server than normal?

Last Reviewed:
5th January 2024

When connecting to the Microsoft SQL Server ODBC driver through the ODBC-ODBC Bridge, you may find more tables are visible than when connecting directly to the same Microsoft SQL Server data source with the same username and password. By default, the Easysoft ODBC-ODBC Bridge Server for Windows NT is installed as a service running with administrator privileges. When the ODBC-ODBC Bridge client connects to the server, you pass a login username and password that the ODBC-ODBC Bridge Server uses so it can become the specified user. For Microsoft SQL Server data sources using trusted connections, the Microsoft SQL Server ODBC driver appears to notice you were an administrative user and are now someone else (possibly noticing the real and effective UIDs). Depending on how your database is set up it may then show you tables you would not have otherwise seen.

If this causes you concern you can change the ODBC-ODBC Bridge Server service to run as someone other than the administrative user. You do this by starting the service manager administrative program in the Control Panel and editing the startup options to specify a username and password. You should then stop the ODBC-ODBC Bridge Server service and restart it.

Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)