INF: How Q+E Handles Table Permissions in SQL Server

  - Microsoft SQL Server version 4.2 for OS/2

SUMMARY

Once a user has logged onto SQL Server with Q+E, the File Open command (from the File menu, choose Open) is used to access database tables. After issuing the command, a dialog box appears that contains both a Table List and an Owner List. The Owner List contains SQL Server database names enclosed in square brackets ([pubs]). It also contains user names for the selected database. The Table List contains a list of tables that the selected username owns.

If you log onto SQL Server with Q+E using a specific username and choose the File Open command, the Table List only displays objects the username has created and owns. Objects the username has permission to access are not displayed in the Table List. To access these objects from the Table List, you must first select the DBO (database owner) username in the Owner List. Because the DBO is the owner of all objects in the database, the desired tables will then be included in the Table List. At this point, you can select and open the tables.

It is important to note that while selecting DBO allows you to open your tables from the Table List, there also may be tables listed that you do not have permission to access. If these tables are selected, Q+E will give you a warning, and the table will not be opened.

MORE INFORMATION

For more information on how Q+E handles SQL Server permissions, see Appendix D, "Using Q+E with SQL Server," in the "Q+E for Microsoft Excel User's Guide."