Error while creating features in Arc SDE featureclass
Hi All, I am facing an edit issue on Arc SDE geodatabase.
Scenario : We have all our feature classes under 'ASSET' schema which is the owner. And we created an additional user 'TEST1' in database and provided Read/Write permission at database level and provided the same permission on Arc Catalog using Manage--->Privileges with SELECT\INSERT\UPDATE\DELETE privileges.
Issue : I created an ArcSDE connection with ASSET user and i am able to edit the feature class like create feature, update,etc.
But when i create an ArcSDE connection with TEST1 user, i am getting the following error 'The Create Feature task could not be completed. Underlying DBMS error'
Kindly help in resolving this issue.
Platform:
ArcGIS Desktop 10.2.1
Arc SDE 10.2.1
Oracle 12 C
Thanks,
Srini
Srini1907@gmail.com
Hello,
Did you find a solution for this problem? We face the same issue for a feature class in an SQL Server database.
I granted Select/Insert/Update/Delete privileges to the user, but he's still not able to create new features:
Check the properties of the database version (if no versions, then it will be default). If you right-click on a connection file (that has access) and select Administration -> Administrate Geodatabase, the Versions tab should show this info
We use versioning and keep our default as Protected. Then if we make a version for a user, they are the owner of tat version and we keep it as Private. We do this to keep mutliple users from working on the same version, and keep Protected on the default to prevent accidental modification.
If that doesn't help, include info on Software version, SQL version, etc. Make sure you have all the requirements for the version, include the proper Microstoft native client on the user machine.
