ArcGIS Enterprise 10.7.1 - Is is possible to lock/portect feature class from deletion in ArcGIS Enterprise?

03-03-2021 02:39 AM
Occasional Contributor III


I am using an ArcGIS Enterprise database and as a table owner, I am wondering if I can "lock" some feature classes to prevent accidental deletion, just as present deletion option for items in Portal. Is it possible?


0 Kudos
3 Replies
MVP Frequent Contributor

I don't think that is available at the database level if you have dba privs and are using operating system authentication.

Maybe use database authentication as a different user or as a safety switch create & point to views as a different user with database authentication instead of the sources directly.

Esri Contributor

@BillFox has pretty much nailed it - if you have database owner privileges or you own the schema that you're working against, then there's nothing that I can think of to stop you from accidentally deleting tables.

Ideally, you should have a login with elevated privileges that you only use for administrative purposes, and for everything else you use another login with the appropriate privileges (read or write) for whatever activity you're undertaking.  Unfortunately it isn't really possible to get this level of granularity if you're required by your organization to use Windows Authentication.

0 Kudos
Occasional Contributor III

Thanks for your suggestions.

I understand in Enterprise GDB, directly in ArcGIS Desktop/Pro, there is no option to 'lock' feature classes. I was just looking at something to prevent accidental deletion from myself as I am the table owner with all the privileges. For editing and viewing workflows, I do have other database users (with authentification) with correct privileges. Nothing much more I can do I think.

0 Kudos