|
| ||||||||||||||||||
Easysoft ODBC-ODBC BridgeWhy can I see more tables in MS SQL Server than normal? |
|
When running the OOB client connected to the OOB Server and the MS SQL Server ODBC driver you may find more tables are visible than when connecting directly to the same MS SQL Server data source with the same username and password. By default the OOB Server for Windows NT is installed as a service running with administrator privileges. When the OOB client connects to the server you pass a login username and password which the OOB Server uses so it can become the specified user. For MS SQL Server data sources using trusted connections the MS 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 OOB Serverservice 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 OOB Server service and restart it.
