ArcSDE 9.2 SP 6 SQL Server 2000 Permissions Patch

This patch resolves an issue introduced at 9.2 SP6 by installing the Connection Performance and Geodatabase Repair Patch, or any subsequent patches. SQL Server 2000 users in the sysadmin, db_owner or db_datareader roles can see all data in the database. At 9.2 SP6, this permission is no longer honored by ArcSDE. When connecting, users no longer see any data unless owned by them. We recommend all SQL Server 2000 users download and install this Patch to resolve this issue.

ESRI® announces the ArcSDE 9.2 SP 6 SQL Server 2000 Permissions Patch. This patch fixes an issue with SQL Server 2000 users who are members of database or server roles not being able to see data that they do not own. We recommend that anyone using ArcSDE 9.2 SP 6 with SQL Server 2000 download and install this patch at their earliest convenience. It deals specifically with the issues listed below under Issues Addressed with this Patch.

Issues Addressed with this Patch

NIM045639 - Users who are members of database or server roles like sysadmin or db_datareader cannot see data that they do not own.
Description: After applying the ArcSDE 9.2 Connection Performance and Geodatabase Repair Patch, the ArcSDE 9.2 SP6 Memory Allocation Patch, or the ArcSDE 9.2 SP6 Compress with Concurrent Editors Patch, users who inherit permissions from membership in SQL Server roles such as sysadmin (DBO), db_owner, or db_datareader can no longer see data that they do not own and have not been explicitly granted SELECT permission on. This affects SQL Server 2000 only. Applying the Permissions patch will resolve this problem, allowing users to see data correctly again.

Files Installed in this Patch

ArcSDE\bin folder:
- giomgr.exe
  gsrvr.exe
  gsrvrsql92.dll
  sde.dll
  sdegdbrepair.exe
  sdesqlsrvr92.dll
ArcSDE\lib folder:
- jsde92_sdk.jar
ArcSDE SDK/Client:
- bin\gsrvrsql92.exe
  bin\sde.dll
  bin\sdesqlsrvr92.dll
  lib\jsde92_sdk.jar

Installing this Patch

Since this Patch replaces 9.2 Service Pack 6 files, you must have ArcSDE 9.2 Service Pack 6 installed before you can install this Patch.

Install this Patch using an administrator account. Make sure you have write access to the ArcSDE installation folder, and that no one is using ArcSDE.

Download the appropriate file to a location other than your ArcSDE installation location.

ArcSDE Server	sde92SP6-sqlpatch-sql-win.EXE	3 MB
ArcSDE Server SDK	sde92SP6-sqlpatch-sdk-win.EXE	3 MB

Double-click sde92SP6-sqlpatch-sql-win.EXE or sde92SP6-sqlpatch-sdk-win.EXE to start the install process.
When Setup starts, follow the instructions on your screen.
Server Only: As the ArcSDE administrative user, run the following command to restart the ArcSDE service:

c:\sdemon -o start

ESRI products connecting to ArcSDE (application server and direct connections)

Windows
- If you connect to ArcSDE 9.2 SP 6 using ArcGIS 9.2 SP 6, ArcIMS 9.2 SP 6, or ArcInfo Workstation 9.3, please follow the steps below to install this Patch to your ArcGIS 9.2 SP 6, ArcIMS 9.2 SP 6, or ArcInfo Workstation 9.3 installation folder:
- Before you start, make sure you have write access to the installation folder, then download the zip file to that location:
  
  sde92SP6-sqlpatch-esri-win.zip 3 MB
- ArcIMS only, stop the ArcIMS Tasker, ArcIMS Monitor, ArcIMS Application Server (in that order).
- Extract the new files from sde92SP6-sqlpatch-esri-win.zip to the appropriate installation folder, see list below:
- - ArcGIS Desktop, Server, Engine, Reader, or ArcView 9 - <installation-folder>\arcgis\bin
  - ArcGIS Workstation - <installation-folder>\arcexe9x\bin
  - Depending on the ArcIMS Setup features installed, SDE client files could be located in one or more of the following locations:
  - - C:\Program Files\ArcGIS\bin
      C:\Program Files\ArcGIS\ArcIMS\IndexBuilder
      C:\Program Files\ArcGIS\ArcIMS\Metadata\Commands
      C:\Program Files\ArcGIS\ArcIMS\Server\bin
- ArcIMS only, restart ArcIMS Application Server, ArcIMS Monitor and ArcIMS Tasker (in that order).

Patch Updates

Check Online Support Center periodically for the availability of additional patches. New information about this Patch will be posted here.

August 3, 2009: Changed instructions on how to identify patched files for Windows.

How to identify which Patch is installed

To check for the presence of a Patch, for each file examine the File version information (right click, properties, version tab). With only a few exceptions, all files modified as part of a Patch distribution can be uniquely identified in this manner. The File version for this Patch should read:

9.2.6.1298

Getting Help

Domestic sites, please contact ESRI Technical Support at 1-888-377-4575, if you have any difficulty installing this Service Pack. International sites, please contact your local ESRI software distributor.

Download ID:1531