topic Re: ArcSDE Mystery Editing Error in Data Management Questions

ArcSDE Mystery Editing Error

KarimHussein — Wed, 16 May 2012 05:55:11 GMT

I am working on ArcSDE geodatabase, I have privilege on one Schema called E_USER, but when I am trying to save my edits on any feature or table "let's say E_USER.Incidents" on this schema I got this error

Unable To Save Edits
Insufficient Permissions[Insufficient privileges to table A_USER.PPL_AREA the current user lacks full access to table.]

As you can see I am working in different schema and different table but always got this error.

Any help will be appreciated.

Regrads

Kareem

Re: ArcSDE Mystery Editing Error

Sergiydodon — Fri, 06 Jul 2012 07:58:08 GMT

I have same problem and I don't know what to do with it.

I've already post about it to forum but no answer

http://forums.esri.com/Thread.asp?c=158&f=2290&t=298974

please help!!!

one thing that I know if you give select, delete, update to that dataset, where that layer located then it become to work, but it's not solution.

Re: ArcSDE Mystery Editing Error

JoeBorgione — Fri, 06 Jul 2012 11:08:46 GMT

Not sure if this will help you guys or not; while I've never had this particular error, schemas can be on the maddening side.

Re: ArcSDE Mystery Editing Error

EduardoCamargo_de_Araujo — Fri, 06 Jul 2012 13:56:09 GMT

Grant privileges using the Change Privileges Tools (ArcToolBox -> Data Management Tools -> Database) to your user and try.

Re: ArcSDE Mystery Editing Error

Sergiydodon — Tue, 10 Jul 2012 12:48:44 GMT

Grant privileges using the Change Privileges Tools (ArcToolBox -> Data Management Tools -> Database) to your user and try.

but I don't want to give to the user rights to the dataset where layer located.
I'll try to explain more clearly. I have two datasets A and B. User, for example, userA granted rights to datasets A and he edits layers from dataset A, but ArcMap says isufficient Permissions[Insufficient privileges to table PPL_AREA the current user lacks full access to table] which is locvated in dataset B.... I didn't made any joins inside database, so i dont't understand what is that....

Yes you're right if I give userA right to dataset B for write, will be fine, but i don't want. Thanks/

Re: ArcSDE Mystery Editing Error

KimPeter — Mon, 16 Jul 2012 21:12:55 GMT

Hi all,

As Vince pointed out in this forum post, ArcSDE doesn't control database privileges. ArcGIS clients have tools, such as the Privileges tool, that allow you to grant UML privileges to datasets, but those just pass the SQL grant or revoke statements to your DBMS. What DBMS are you using?

@Karim, who are you logged in as when you try to edit PPL_AREA? Did you use the ArcGIS Privileges tool to directly grant INSERT, UPDATE, and DELETE privileges on PPL_AREA to that login (user)?

@Sergiy, I'm not sure what you mean by

Yes you're right if I give userA right to dataset B for write, will be fine, but i don't want.

If you don't grant write access on dataset B to userA, userA will not be able to edit dataset B.

Re: ArcSDE Mystery Editing Error

ShannonShields — Mon, 16 Jul 2012 21:50:17 GMT

I am working on ArcSDE geodatabase, I have privilege on one Schema called E_USER, but when I am trying to save my edits on any feature or table "let's say E_USER.Incidents" on this schema I got this error
Unable To Save Edits
Insufficient Permissions[Insufficient privileges to table A_USER.PPL_AREA the current user lacks full access to table.]

Karim,

Is it possible that there is a relationship class between E_USER.Incidents and A_USER.PPL_AREA? If there is, and you haven't been granted permission to A_USER.PPL_AREA then you may not be able to successfully edit the Incidents table.

-Shannon

Re: ArcSDE Mystery Editing Error

KarimHussein — Tue, 17 Jul 2012 04:23:17 GMT

Greetings all,

I would like to thank you all guys for your help.

I discovered that there is a bug NIM059451 "http://support.esri.com/en/bugs/nimbus/TklNMDU5NDUx" in ArcSDE that causing this error only when you register your tables or feature class with the option of move edits to base, the only solution now is to uncheck this option when you register any table or feature class, however I faced another problem when I did that, that I am now cannot create multiversion view for these tables that were registered without the option of move edits to base, I am trying to find a solution and I will get back to you.

Finally I hope that Esri fix this bug in ArcGIS 10.1

Warm regards,

Karim

Re: ArcSDE Mystery Editing Error

WilmarCruz_Ruiz — Mon, 28 Jul 2014 20:22:45 GMT

Hi Karim, did you finally found any solution for this in V10.0 ?

Thanks for your help

Re: ArcSDE Mystery Editing Error

GeoffMartin — Mon, 15 Sep 2014 23:38:39 GMT

We are getting the same error having just migrated from ArcGIS/ArcSDE 10.0 --> 10.2.2 and configured Versioning to Edits to Base.

Anyone found a solution?

cheers

Re: ArcSDE Mystery Editing Error

AsrujitSengupta — Mon, 15 Sep 2014 23:44:24 GMT

NIM059451 - The error "Unable to save edits. Insufficient perm..

As mentioned in the posts above, it is a known Bug if your data is 'Registered as Versioned with Move Edits to Base'

Re: ArcSDE Mystery Editing Error

Laura — Fri, 16 Feb 2024 18:44:08 GMT

I get the same error and issue in pro without versioned data