Cannot delete feature class from enterprise geodatabase

1102
3
Jump to solution
08-22-2017 01:20 PM
Highlighted
Occasional Contributor II

I have a geodatabase version 10.2.1 in SQL Server 2008 R2.  It has only two feature classes in it.  I have a database role in that database called 'DBEditors'.  If I look at the privileges for the feature classes using ArcCatalog, it says that DBEditors has Select, Insert, Update, and Delete privileges.  I have a user who is a member of the DBEditors group in the SQL database - I see this in SQL Server Management Studio under Database Role Properties.  However, the user says that the delete option for the feature classes is greyed out in her ArcCatalog.

The feature classes are not in any topology and they are not connected to any feature services.  The owner is DBO and they are not registered as versioned (they were, but I unregistered them).  No one else has any locks on them (according to Geodatabase Administration).  I've looked in SQL Studio and I don't see any duplicate/orphaned records in GDB_ITEMS or SDE_table_registry with the same tablename.

What else can I do?

Reply
0 Kudos
1 Solution

Accepted Solutions
Highlighted
MVP Regular Contributor

The owner is DBO

This is the reason. Only the owner of a data, will have the option to delete it. So in this case, any user with SYSADMIN server role assigned to them can be used to delete the Feature class.

 If I look at the privileges for the feature classes using ArcCatalog, it says that DBEditors has Select, Insert, Update, and Delete privileges.

These Select, Insert, Update, and Delete are pointing to the permission to edit data inside the feature class. You can select(view) an existing, Insert new records, Update existing records and Delete a record from that feature class, with these privileges granted.

View solution in original post

3 Replies
Highlighted
MVP Regular Contributor

The owner is DBO

This is the reason. Only the owner of a data, will have the option to delete it. So in this case, any user with SYSADMIN server role assigned to them can be used to delete the Feature class.

 If I look at the privileges for the feature classes using ArcCatalog, it says that DBEditors has Select, Insert, Update, and Delete privileges.

These Select, Insert, Update, and Delete are pointing to the permission to edit data inside the feature class. You can select(view) an existing, Insert new records, Update existing records and Delete a record from that feature class, with these privileges granted.

View solution in original post

Highlighted
Occasional Contributor II

Thank you!  I was mixed up between deleting the feature records and deleting the feature class itself.

Your answer makes complete sense.

Reply
0 Kudos
Highlighted
Honored Contributor

Could you please mark Asrujit's answer as correct, if it answers your query satisfactorily?

Reply
0 Kudos