Unable to create locator with alternate table if not owner of the table
上次发布: August 25, 2014No Product Found
漏洞 ID 编号
NIM001179
已提交
February 20, 2006
上次修改时间
April 2, 2025
适用范围
No Product Found
找到的版本
9.1
修正版本
9.2
状态
Fixed
此漏洞已得到修复。 有关详细信息,请参阅“版本修复”和“其他信息”(如果适用)。
解决办法
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.