nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

JamalNUMAN

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

Clip_278.jpg

test.zip

Find more posts tagged with

Accepted answers

Anonymous User

Original User: cherylc

Hi Jamal

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

Regards
Cheryl

All comments

Anonymous User

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]

Clip_315.jpg

Clip_314.jpg

Correct Format.xls

QuarterSec_Script.png

EmadAl-Mousa

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,

Anonymous User

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

Screenshot 2023-05-04 130353.png

LastYear.JPG

Sidebar App - Tables.png

Instant Apps Editing Issue compressed.mp4

EmadAl-Mousa

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,

Anonymous User

Original User: cherylc

Hi Jamal

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

Regards
Cheryl

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.