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.
© 1993 - 2024 Easysoft Limited. All rights reserved. Oracle® is a registered trademark of Oracle® Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.
