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; } } }

Insufficient Permissions when trying to delete feature class from Oracle SDE in Catalog

ZacharyPierce

I am connected to the sde as SDE user. I am trying to delete a feature class but get the error : Failed to delete selected objects. Insufficient Permissions [Insufficient Permissions [SDE]].

Can someone please help on how I can grant the SDE user permissions to delete feature classes from with Arc Catalog.

I have sys access with sysdba privileges I can run it on.

Thanks..

Find more posts tagged with

Accepted answers

JakeSkinner

The display of feature classes in Catalog will be:

For example,

GIS.Parcels

GIS is the data owner, and Parcels is the feature class name.

All comments

JakeSkinner

Hi Zachary,

You will need to be connected to the database as the data owner in order to delete a feature class using ArcCatalog, regardless of what permissions you have.

VinceAngelo

The SDE user should not have the ability (or need) to delete tables owned by other users. All DROP TABLE commands should be executed by the owner, though tables should be deleted at the highest level of administration (tables registered as feature classes with the geodatabase should be removed with ArcGIS/Python/ArcObjects; tables registered with ArcSDE should be deleted with 'sdetable -o delete'; and simple tables can be dropped with an SQL client).

In the future, please post questions "In a Place", not in your own discussion space, and be sure to tag each question with at least 4-5 relevant keywords.

- V

ZacharyPierce

How can I verify what schema is the data owner? I tried connecting with 4 schemas, and the sys user, I do not have an option to select the delete function.

ZacharyPierce

Vince,

Thanks for the advice on the forum ettiquutte, I thought I did all that but I guess not. The new design is throwing me off.

As far as the original questions, I am not to versed in python/arcobjects. Are you saying that I need to script out to drop a feature class, and this cannot be handled in ArcCatalog? If it can, any insight on how I can find out the owner user to connect with, I thought it was SDE.

Thanks,

Zach

JakeSkinner

The display of feature classes in Catalog will be:

For example,

GIS.Parcels

GIS is the data owner, and Parcels is the feature class name.

ZacharyPierce

Thanks so much!

I was able to perform the task I was looking to do by your suggestion.

Cheers

ZacharyPierce

Vince,

I am not sure how to give you credit as well, but I went with the previous reply as it solved the issue I had. Thanks for your input and knowledge about the proper way to handle these situations.

cheers

VinceAngelo

As a staff member, I'm not eligible for any exciting gifts (neither is Jake), so it's not a big deal. I think marking the useful bits "Helpful" grants points.

- V

VinceAngelo

You can still move this discussion (to GIS->Data Management) using the right-side menu "Move" option.

Not at all. I merely listed the three methods available:

ArcGIS [both Desktop and Server], which is written with ArcObjects,
The ArcPy Python module, which is written with ArcObjects, and
ArcObjects, which is written using the ArcSDE API.

I've pretty much moved over to using the Catalog window of Desktop for all my geodatabase administration needs.

It is in fact best practice to never connect as SDE, except for things which require it -- instance and version management.

- V

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.