Latest Contributions by RussellBrennan

Yes ... View more

Can you post some of the code that you are trying to execute? There is an example in the help for how to work with this: import arcpy import os fc = 'Database Connections/Portland.sde/portland.jgp.schools' workspace = os.path.dirname(fc) # Start an edit session. Must provide the worksapce. edit = arcpy.da.Editor(workspace) # Edit session is started without an undo/redo stack for versioned data # (for second argument, use False for unversioned data) edit.startEditing(False, True) # Start an edit operation edit.startOperation() # Insert a row into the table. with arcpy.da.InsertCursor(fc, ('SHAPE@', 'Name')) as icur:    icur.insertRow([(7642471.100, 686465.725), 'New School']) # Stop the edit operation. edit.stopOperation() # Stop the edit session and save the changes edit.stopEditing(True) ... View more

The WITH GRANT option is only available from the database using database level tools. I would not recommend using this privilege to manage privileges for data in an enterprise geodatabase, especially when data is contained in a feature dataset. There are many cases (too many to list) where an ArcGIS dataset is not just one table but many tables in the underlying DBMS. If you use database tools to manage privileges on these datasets and happen to miss one of the underlying tables you will run into issues reading and writing this data. This can lead to data corruption and a lot of sadness. Please stick to managing privileges for datasets with Esri tools. The recommended approach to this is to load data using a 'headless' user. This user could be a database user or an OS authenticated user that isn't associated to someone specific in your organization. Loading data as this user will allow you to manage privileges using this user. Hope this helps, Russell ... View more

I cannot directly answer your question because I am personally not familliar with all of the local government maps/apps and if they rely on editor tracking fields. I would suggest that rather than using the 'Manage > Enable editor tracking' option to enable editor tracking that you use either the GP tool or go to the properties page for the dataset. Using either of these options allows you to specify an already existing field to use for any of the four editor tracking fields. You could point to the existing LASTUPDATE and LASTEDITOR and use these instead. Hope this helps, Russell ... View more

Hi Clara, I just sent you a message with my email address. ... View more

Hi Clara, I am glad to hear that you are on your way and things are working as expected. I tried a simple test on my end to try to reproduce this issue but was unsuccessful. Were you viewing the records in Oracle or in ArcGIS? If using Oracle tools to view the data you may not have seen the edits in the table because they would be stored in the delta tables. I would like to track down the cause of this issue, are you able to send me the version of desktop and geodatabase that you are working with? Thanks, Russell ... View more

Hi Clara, Are you working with hosted feature services, either ArcGIS online or Portal for ArcGIS (with datastore)? Russell ... View more

The Rebuild Indexes tool will rebuild indexes on two different 'types' of tables in your geodatabase. In the case of the rebuild indexes tool we have separated the tables into 'data tables' and 'system tables'. Data tables are the tables that you get returned when you run any of the list functions (like what you are doing in your script). System tables are those used by the geodatabase internally (states, state_lineages table for example). Within the tool there is a parameter 'include_system' with options 'SYSTEM' and 'NO_SYSTEM'. When you choose 'SYSTEM' you need to be connected as the geodatabase administrator, because only the geodatabase administrator has privileges to update indexes on these tables. In some cases you may want to only update the system table indexes. You can do this by running the tool and providing the 'SYSTEM' parameter and NOT providing any other datasets in the in_datasets list. If you try to run the tool using 'NO_SYSTEM' and NOT providing any other datasets in the in_datasets list the tool will fail. It appears that since you are using the SYSTEM parameter the tool is executing properly. Through Python we do not find all of the datasets that your user owns and automatically update indexes, you need to provide the list. To answer your side question, when using geoprocessing/python the permissions are coming from the .sde connection file. In the case that you are using Operating System Authentication in your .sde connection file the permissions will then come from the OS user who is running the script. ... View more

You do not need to be working in an enterprise (SDE) geodatabase to schedule scripts to run. This can be accomplished via the windows task scheduler on Windows or a cron job on Linux. Below are two links for how to do this on Windows. Skip to 44:30 in this video to see how to use the task scheduler to call a python script: Administer Your Enterprise Geodatabase through Python | Esri Video‌ Also, there is a blog post on this here: Scheduling a Python script or model to run at a prescribed time | ArcGIS Blog ... View more

Geodatabases on the SQL Express platform were traditionally managed solely through ArcCatalog. This was done to provide an easy user experience to the geodatabase admin. Through ArcCatalog there were options for adding users, backing up and restoring the database. There were also options for viewing and managing user privileges. We provided what we felt was a few (suitable and easy to understand for SQL Express admins/users) roles that admins could use to administer privileges. These are the roles that you were asking about. We did not however, provide an option for creating new roles. With enterprise geodatabases on SQL Server we do not limit what roles you want to use and do not make any assumptions about the roles you want to create. This gives more flexibility to admins who want more discreet or more general roles for their organization. These admins typically configure and manage their geodatabases using a combination of SQL Server Management Studio as well as ArcCatalog. ... View more