FAQ: Why is the use of an address locator geocoding service in ArcSDE limited to the owner?
Why is the use of an address locator geocoding service in ArcSDE limited to the owner?
To use an ArcSDE address locator, a geocoding service, a user must have SELECT privileges on the reference datasets and geocoding index tables used by the address locator. Geocoding index tables are named with a prefix of 'GC_'.
Only the owner of the ArcSDE dataset may grant privileges to the dataset.
Grant select privileges to these datasets by right-clicking the dataset in ArcCatalog and clicking Privileges. Type the name of the user to receive privileges, check 'select', and click OK. Do this for each reference dataset and geocoding index table used by the locator, and for each user that requires privileges.