Latest Contributions by AsrujitSengupta

No, I wrote that for creating/loading of new data.....not for editing existing data. For editing existing data, you just need to grant the Logins sufficient permissions either on the database (db_reader, db_writer) or on individual data (ArcCatalog privileges) However, to create/load new data using the DBO schema----you'll have to grant sysadmin to the other users. That is the reason, its advisable to create a common Login for loading/creating new data into the sde gdb and I'll suggest you the same, unless you specifically need to load it with DBO-Schema ... View more

Jill, According to the description provided under "Specifying how user names are recorded" in the below link, this should not be occurring if your user is always using lower-case to login. About tracking an editor's changes to data: http://resources.arcgis.com/en/help/main/10.1/index.html#//01m600000068000000 Maybe you can suggest them to try creating a new connection, just to check if the behaviour is reproduced. ... View more

Tim, You don't really need the db_owner to create/load data in that sde geodatabase. The following permissions will suffice as well: CREATE FUNCTION CREATE PROCEDURE CREATE TABLE CREATE VIEW To check what permissions your login has right now, Connect to the Instance in SQL Server-->R-Click on the database-->Permissions-->Select your user from the list-->Effective----This will list all the permissions that the login has on that database User privileges for geodatabases in SQL Server: http://resources.arcgis.com/en/help/main/10.1/index.html#//002q0000002s000000 ... View more

Tim, As mentioned in the below link, "Remember, the user name and schema name must be the same if this user is going to own data." -- Point #14 Adding database-authenticated logins to a SQL Server database: http://resources.arcgis.com/en/help/main/10.2/index.html#//002q0000002m000000 Instead of trying to match the username with the Default Schema assigned by Microsoft SQL Server (which is dbo)....you simply need to match the 'Default Schema' with the username ( if username is X--> the default schema should be X as well) If a Login has been granted "sysadmin" privilege, it automatically becomes a DBO and its schema is taken as 'dbo'. NOTE: This is same for both DBO-Schema and SDE-Schema geodatabases. ... View more

Its just teasing you! 🙂 ... View more

It always helps if you provide the configuration details (atleast the version of ArcGIS Desktop in this case) HowTo:  Connect to Microsoft Access 2007/2010 (ACCDB) files in ArcGIS: http://support.esri.com/fr/knowledgebase/techarticles/detail/32976 HowTo:  Use Microsoft Access tables in ArcGIS: http://support.esri.com/en/knowledgebase/techarticles/detail/30770 Connecting to a Microsoft Access database in ArcGIS: http://resources.arcgis.com/en/help/main/10.1/index.html#//005s00000023000000 ... View more

I would directly suggest discussing this with ESRI Tech-Support for better troubleshooting. ... View more

These links may help: Example: Discovering domain usage using SQL http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//006z000000t9000000 List Fields and Associated Domains http://forums.arcgis.com/threads/60025-List-Fields-and-Associated-Domains-gets-stuck-on-one-table-why Find fields for domain in SDE 10 http://forums.arcgis.com/threads/4625-Find-fields-for-domain-in-SDE-10 ... View more

Copy that Feature Class to a File gdb and run 'Check geometry" tool on that. It should list all the features with invalid geometries. Then you can either go through the features reported in this and correct them OR run the "Repair Geometry" tool, which will repair these. Then copy this corrected FC back into the postgreSQL database and try again. However I would suggest you read about these tools a bit before executing them! Checking and repairing geometries: http://resources.arcgis.com/en/help/main/10.1/index.html#//001700000042000000 Check Geometry (Data Management): http://resources.arcgis.com/en/help/main/10.1/index.html#//001700000034000000 Repair Geometry (Data Management): http://resources.arcgis.com/en/help/main/10.1/index.html#//00170000003v000000 ... View more

simply stated the "process_admin" server role along with db_owner should be sufficient! ... View more

Vikram, To disconnect users, the geodatabase administrator may need additional privileges. The geodatabase administrator (sde) in an sde-schema geodatabase requires VIEW DEFINITION privileges on the database to see the list of connected users, and must be a member of the processadmin fixed server role to disconnect users. If the geodatabase administrator of a dbo-schema geodatabase is the database owner, the geodatabase administrator must be added to the processadmin fixed server role to disconnect users. No additional privileges are required for the geodatabase administrator in a dbo-schema geodatabase if the geodatabase administrator is a member of the sysadmin fixed server role. Removing connections from a geodatabase in SQL Server: http://resources.arcgis.com/en/help/main/10.1/index.html#//002q000000r8000000 ... View more

Remark: At the moment, there is no GEOPROCESSING tool that can create replica from the enterprise gdb to the file gdb. 1. The �??create replica�?� tool doesn�??t allow tables (non-spatial data) to participate in the replica 2. The �??create replica�?� of tool bar requires adding all the layers of the enterprise gdb to the ArcMap to create the replica. This is itself a headache What I�??m looking for is one single tool that can take all the updates from the source to the destination IN ONE GO. This tool is supposed to: 1. Delete the existing file gdb (destination) 2. Create new replica between the enterprise gdb (source) and the file (destination) Jamal, You can surely complete the above task, but not with ONE single tool! You can use the 'Delete' tool to delete the File geodatabase and then use the below workaround to create the Replica. >>Create a model using the 'Make Table View' and the 'Create Replica' tools. > Pass the standalone table to the 'Make Table View' tool and set a filter in the expression. eg. Objectid>=1 can be used if the entire table is being replicated. > Pass the output of the 'Make Table View' to the 'Create Replica' tool and define the various parameters. Reference: Create Replica on SDE Table: http://forums.arcgis.com/threads/48195-Create-Replica-on-SDE-Table?p=166604#post166604 However, I am not sure if this will help, as you will have to manually "Unregister the Replica" to create another replica with the same name.(or you'll have to manually change the replica name everytime to a new one) As Marco pointed out, the NIM seems to be fixed in an upcoming release, so you should be able to synch more than 1000 records (features) deleted. Regards, ... View more