Latest Contributions by HaniuHokkaido

dear experts, I am confused. I create a new login "dbadmin" with Server Role : Public, Diskadmin, securityadmin,sysadmin, serveradmin and dbcreator I already have a geodatabase with the system table under schema SDE. and also i have some tables under DBO schema With this dbadmin, i create a Database Role: role_editor, and also i create user named "user_editor". User_editor is member of role_editor In the Database Role property for role_editor, i specify permission for dbo: SELECT,INSERT,ALTER,EXECUTE,DELETE and UPDATE. For sde, i do not specify any permissions. Question is: 1. when i log on as user_editor, I can see all tables in SDE schema. I can do "select * from sde.tabelxxx" too. Why ? Should SDE tables be hidden ? 2. Then I change the permission of sde in Database Role role_editor so that the SELECT is DENY. Then I cant do SELECT. Why should I specify DENY SELECT for SDE schema ? Shouldnt SELECT is automatically denied since i do not state the permission on SDE schema ? 3. Shouldnt it the other way around, i should specify permission in the Database Role for SDE schema instead of DBO ? [Database: SQL Server 2012, ArcSDE 10.1] Thanks ... View more

dear expert, I have 2 FCs, a line and polygon. I want to find out which lines are not fully contained within a polygon. Is there such topology rule for this ? thanks ... View more

Hello experts, Suppose I have 2 FC that some of the objects are intersecting each other. Suppose I edit an object in FC 1. And the object is intersecting an object (or some objects) in FC 2. Now, how can the edit (attribute editing) of object in FC 1 affect the attributes of object(s) in FC 2 ? How can i acheve this simultaneous editing ? The geometry is not stored in GEOMETRY or GEOGRAPHY data type This is relatively,in theory, easy if I do it via sql trigger given that the FC is stored in GEOMETRY or GEOGRAPHY data type. Environment: Arcgis 10, sqlserver 2008. Thanks ... View more

dear experts, For technical reason, I change (add) the Server Role for user "SDE". Previously it was "Public", now I add "SYSADMIN" What are the implications ? One known implication is that the attribute in FC cant be edited via ArcCatalog. Can anyone explain why i cant edit my FC using user SDE after I add SYSADMIN to SDE? I am using SQL Server Thanks ... View more

Dear experts, I want to build an application that combined Flex Viewer (build with ArcGiS Viewer for Flex Builder 3.5 app) and custom .NET app to handle login. Different users will have access to different layers. The Flex Viewer itself has many layers but only certain layer(s) can be accessed by certain users upon successful log-in. And also, the address for Flex Viewer cant be accessed directly without log-in .. I do not want to modify the generated Flex Viewer app. Is it possible ? If yes, How can i do this ? Do i have to secure each service ? If I have to secure some of the services, does it mean that ALL the map services in that particular server have to be secured  ? I need some advice. Please [I have arcgis server 10. Visual Studio 2008.] Thanks ... View more

Hi, I just made an application from Arcgis Viewer for Flex 3.5 using Map Service from Arcgis Server 9.3.1. Why does the map appear in gray scale ? [ATTACH=CONFIG]29706[/ATTACH] I tried to make an app with arcgis server wizard, the map appears in color. FYI, The map service has 3 layers (1 basemap and 2 operational) taken from arcgis server local. The map service is very simple, just single color. and its a dynamic map service Please help... thanks ... View more