Oracle 18c/10.7.1 geodatabase:

My geodatabase has an owner/schema/user called OPERATIONS.

Operations staff have a direct db connection in ArcMap/Catalog to the OPERATIONS owner. This connection is needed so that staff can create and alter tables in OPERATIONS.

I want to prevent Operations staff from deleting tables in the OPERATIONS owner.

What are my options for doing this?

  • Fire them if they delete tables? If you grant someone the access to CREATE and ALTER tables, that also gives them the right to DROP as well. If you don't trust your operations staff to do the right thing, then they shouldn't have the password to that login. While I won't say I've never altered a table, I will say that it doesn't and shouldn't happen often. Infrequent enough that a batch script can run with the necessary permission. – Vince Sep 6 '20 at 18:25
  • 1
    I think the question is not about GIS but about Oracle and might belong better to db admin site. Perhap a trigger like here community.oracle.com/thread/961302 could help. – user30184 Sep 6 '20 at 21:10

Creating Oracle Trigger would help https://asktom.oracle.com/pls/apex/asktom.search?tag=prevent-drop-table

Not the answer you're looking for? Browse other questions tagged or ask your own question.