Bug
Unable to create locator with alternate table if not owner of the table
| Bug ID Number | NIM001179 |
|---|---|
| Submitted | February 20, 2006 |
| Last Modified | April 2, 2025 |
| Applies to | No Product Found |
| Version found | 9.1 |
| Version Fixed | 9.2 |
| Status | Fixed |
Workaround
Workaround to this as suggested by Agatha is:-----------------------------------------------Let's say gisdba = owner of the altname table, Test = user with granted permission of the table1) Gisdba creates an index on the JoinID or AltnameID field of the altname table. Open the Properties dialog of the table in ArcCatalog and click the Index tab. Add the JoinID or AltnameID to the index. 2) We now need to create a custom geocoding style for Test user to use. The easiest way to do this is that we first create locator as Gisdba user, grab the properties of the locator and using those properties, create a new locator style. Here are the steps: 2.1) Create a locator as GISDBA user. This locator should have same properties as you would set if it was TEST user. 2.2) Run the following command against this newly created locator.sdelocator -o describe -i 5151 -n <name of the locator> -u gisdba -p gisdba > alt_names.locwhere -n is the name of the locator you created as GISDBA. This will output a file by name "alt_names.loc" that has locator style properties. 2.3) Open this locator style file in any text editor you are conformable with and find the following line:RD.Table2.Column = JOINID,"Join ID",Y,TRUEReplace this withRD.Table2.Column = JOINID,"Join ID",N,TRUENotice that we have changed one of the parameter that was Y to N. 2.4) Save the file 2.5) Run the following command to create a custom geocoding style templatesdelocator -o create -n "custom_style_altnames" -f "<a href="file:D:/My" target="_blank">D:\My</a> Data\MyProfessional\02-February-2006\476680\alt_names.loc" -T t -S "created for alt names bug" -i 5151 -u gisdba -p gisdba-f is path to the loc file created in step 2.4Please change the other switches appropriately.This will create a new template for you that you can use in ArcCatalog. Please note that this template was created by GISDBA.3) GISDBA grants permission on the feature class and altname table to Test.4) Test can now create locators using the altname style on the table and feature classes given the permission.Steps to Reproduce
Bug ID: NIM001179
Software:
- No Product Found
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App