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

4237
5
Jump to solution
05-21-2014 09:22 PM
JamalNUMAN
Legendary Contributor
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
----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine
0 Kudos
1 Solution

Accepted Solutions
by Anonymous User
Not applicable
Original User: cherylc

Hi Jamal

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

Regards
Cheryl

View solution in original post

0 Kudos
5 Replies
by Anonymous User
Not applicable
Original User: cherylc

Hi Jamal

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

Regards
Cheryl
0 Kudos
EmadAl-Mousa
Occasional Contributor III
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,
0 Kudos
by Anonymous User
Not applicable
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
0 Kudos
EmadAl-Mousa
Occasional Contributor III
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,
0 Kudos
by Anonymous User
Not applicable
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]
0 Kudos