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.
Solved! Go to Solution.
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.
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.
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:
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.
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.