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

How to delete old feature classes from Oracle Geodatabase

AlexanderGray

I have some featureclasses in an sde database that were created by users no longer in the organization. These have been determined as no longer useful. The problem is only the creator of the data has select and insert/update/delete. I am trying to use the sde account to delete the featureclass but it has insufficient privileges. On feature classes I create, if I assign delete privilege to sde, sde can delete the feature class (other users granted delete can only delete rows!) However, I cannot grant myself (sde) privileges to delete these feature classes. I would like to pyScript this up help with data management so geoproc tools are nice. Any one know how to delete the old stuff? Do I need to use SQL and start messing with the SDE tables?

Find more posts tagged with

Accepted answers

Anonymous User

1. The SDE-owned tables are not in any way related to this situation.

2. All you need is any user with dbo permissions. The user can be OS authenticated, or DB -- it doesn't matter. Your DBA can do this. I don't recall the Oracle word; "dbo" might be SQL Server-specific.

Here is a link to Oracle permissions in the geodatabase. In my experience, you might get better results asking for temporary permissions for cleanup activities. ArcGIS Help 10.1

The other alternative, unless the tables are huge, is to revoke SELECT so they don't bother anyone anymore. It sounds like you can likely do that with your current credentials.

In your 9.3 days, the SDE user was possibly granted elevated permissions as part of the geodatabase creation process. After the process was complete, the elevated permissions may have been removed. Whatever happened, you can rest assured that all versions support OS authentication and you do not need to mess with SDE tables or rebuild your database!

All comments

AlexanderGray

Thanks Marianne, I already updated the code that creates the featureclasses to grant delete to the SDE user. The rest will have to be handled as one offs, which is a little annoying since we have to hand this over to a support team for 24/7 operational support. Support are usually not dedicated database or GIS specialists so I will work with the DBA to write this into an SOP.

Anonymous User

1. The SDE-owned tables are not in any way related to this situation.

Here is a link to Oracle permissions in the geodatabase. In my experience, you might get better results asking for temporary permissions for cleanup activities. ArcGIS Help 10.1

The other alternative, unless the tables are huge, is to revoke SELECT so they don't bother anyone anymore. It sounds like you can likely do that with your current credentials.

AlexanderGray

The DBA has no control over passwords, the passwords are not stored in the database. Passwords are maintained by the network administators and would not reactivate the accounts, change the passwords or let me login with their account under any circumstance. They would sooner tear down the database and get me to rebuild it than do that. I am looking for a way to avoid that. If I have to rebuild the database every time someone leaves behind some featureclasses we are in for some serious problems.

AsrujitSengupta

Hence my suggestion of requesting your DBA to alter the password and not try yourself.

AlexanderGray

We use OS authentication so I cannot log in as another user. The passwords are not stored in the database. It would also be a major policy violation to impersonate another user...

AsrujitSengupta

You have to use the data owner to delete those old data. So connect as that user to delete those data.

In case you are unaware of the credentials, ask your DBA to alter the password for that user and then try to connect.

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.