topic Re: Delete failed: �??lock request conflicts with an established lock�?� in Data Management Questions

Delete failed: ???lock request conflicts with an established lock???

JamalNUMAN — Thu, 22 May 2014 04:22:40 GMT

Delete failed: ???lock request conflicts with an established lock???

A layer owner is not able to delete it in an enterprise geodatabase as shown in the screenshots below:

[ATTACH=CONFIG]33989[/ATTACH], [ATTACH=CONFIG]33990[/ATTACH], [ATTACH=CONFIG]33991[/ATTACH]

The enterprise geodatabase accessed by the owner of the layer shows ???insufficient permissions??? as the ???disconnect user??? is selected

[ATTACH=CONFIG]33992[/ATTACH], [ATTACH=CONFIG]33993[/ATTACH]

What might be the issue here? How the owner can???t delete what he\she owns?

Thank you

Best

Jamal

Re: Delete failed: �??lock request conflicts with an established lock�?�

Anonymous User — Thu, 22 May 2014 14:07:07 GMT

Original User: cherylc

Hi Jamal

Connect as the admin user and disconnect the 'old' connection.

Regards
Cheryl

Re: Delete failed: �??lock request conflicts with an established lock�?�

EmadAl-Mousa — Sat, 24 May 2014 13:44:54 GMT

it seems you have orphan connection. either close your ArcCatalog and try again, or check the connection lock using "sde" user geodatabase administrator GUI.

Regards,

Re: Delete failed: �??lock request conflicts with an established lock�?�

Anonymous User — Sun, 25 May 2014 05:10:40 GMT

Original User: Jamal432@gmail.com

Hi Jamal

Connect as the admin user and disconnect the 'old' connection.

Regards
Cheryl

Many thanks Cheryl and Emad for the help. Finally it is deleted

[ATTACH=CONFIG]34064[/ATTACH], [ATTACH=CONFIG]34065[/ATTACH], [ATTACH=CONFIG]34066[/ATTACH], [ATTACH=CONFIG]34067[/ATTACH]

In general,

�?� how the SA can delete a layer considering that he\she is not the owner?

�?� How to disallow users to add feature classes to the database?

Best

Jamal

Best

Jamal

Re: Delete failed: �??lock request conflicts with an established lock�?�

EmadAl-Mousa — Sun, 25 May 2014 05:22:55 GMT

Hi,

SA user in sql server is a powerfull user so the user can drop any database object.

to disallow users to create feature classes, the user connecting the geodatabase should not have the "create table" privilege.

Regards,

Re: Delete failed: �??lock request conflicts with an established lock�?�

Anonymous User — Wed, 28 May 2014 09:58:00 GMT

Original User: Jamal432@gmail.com

Hi,

SA user in sql server is a powerfull user so the user can drop any database object.

to disallow users to create feature classes, the user connecting the geodatabase should not have the "create table" privilege.

Regards,

Many thanks Emad,

Unchecking the �??create table�?� disallow a user to create feature class.

[ATTACH=CONFIG]34121[/ATTACH]

What is missing on permissions is that the admin can�??t disallow a user to be able to export a particular feature class.

[ATTACH=CONFIG]34122[/ATTACH]