topic Re: Can't Delete Feature Class in SDE in Data Management Questions

Can't Delete Feature Class in SDE

IndianaUniversity — Wed, 07 Jun 2017 16:00:59 GMT

I am having trouble deleting a feature class in SDE. I am the DBO for the database, and there are a couple of feature classes in there under a user name that I need to delete. In trying to set permissions, I was given different levels to see what I could and could not do. In doing this. I created a couple of feature classes as tests, and now they won't delete. They are titled ADS/username/layer name. When i'm connected as the DBO, I try to delete them, and I get an error saying that they can't be deleted because I'm not the owner. My thought is that being an owner should allow me to delete these without problem. I have attached a screenshot of the errors that I'm getting.

Thanks in advance for any help on this.

Re: Can't Delete Feature Class in SDE

JakeSkinner — Wed, 07 Jun 2017 19:34:36 GMT

Check to see if the user you are connecting as has the 'sysadmin' Server Role applied to it. If so, remove this and see that the user just has 'db_owner'. You should then be able to delete feature classes owned by other users. I'm not sure if this is by design or a bug.

Re: Can't Delete Feature Class in SDE

ChrisCatania — Fri, 09 Jun 2017 22:05:15 GMT

FYI... Moving the conversation to the Managing Data‌ group.

So you're aware on how and where to post future questions, here's a few quick tips and reminders:

First, use the GeoNet search (top right corner by your profile icon) to search and see if your question has already by asked/answered previously.

If not, than we suggest reviewing the GeoNet Community Structure, to find the most relevant space to post your question.

The GeoNet GeoNet Help group is for questions and tips on how to use the GeoNet community platform not the Esri ArcGIS platform. Following steps 1 & 2 above will give you the best results for getting Esri product questions answered.
This GeoNet 101 "How to Ask Questions on GeoNet" post is also a helpful guide to asking questions: https://community.esri.com/community/help-and-feedback/blog/2016/08/15/community-news-and-tips-how-to-ask-questions-and-get-answers