I have been trying to figure this out for 3 days and I just can???t so I decided to write you to see if you could help me as I believe by watching your videos and talking to you this would be something very familiar to you.
I need to publish a feature service that is editable in ArcMap. I created one geodatabase (using sa and sde passwords). I created one user (LOADINGSARS) to publish the service and created a role to grant permissions to the user. Below is the syntax to create the role. I made sure in SQL, the Default Schema name was the same as the User name and I checked the gis_dataloader database role for the user.
Then I added a database connection using that user account (LOADINGSARS) and created a feature class. I then clicked on the feature class and granted all permissions not only to the role I created (gis_dataloader), but also to my operation system account (that is recognized by the server). When I try to add the user (LOADINGSARS) to the privileges in arcCatalog, it does not keep the user there (I guess because I am connected as the user?). I add LOADINGSARS to the privileges, check "select", insert, update and delete but when I click ok, the user disappears.
I made sure the data in Arcmap was editable and I published the feature service. Then I connected to the server as a user with my operation system account (iwilson) . When I add the feature service to ArcMap I get the error "No editable layers" and the warning "The workspace containing this data cannot be edited" (please see images). The feature service is editable in arcgis.com but not in ArcMap. What would be the problem? Thank you for any help!
USE EDIT_SARS CREATE ROLE gis_dataloader; GRANT CREATE TABLE TO gis_dataloader; GRANT CREATE PROCEDURE TO gis_dataloader; GRANT CREATE VIEW TO gis_dataloader; GO [ATTACH=CONFIG]25030[/ATTACH][ATTACH=CONFIG]25031[/ATTACH]
Yes, you don't have to make a copy of the data if you are consuming the feature service in a web application such as ArcGIS.com or ArcGIS viewer for Flex. However, if you wish to consume the feature service and make edits within ArcMap itself, you will need to use the workflow provided in the link below.