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

タグ付きの投稿をもっと見る

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: cherylc

Hi Jamal

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

Regards
Cheryl

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: 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

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,

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

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

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