You must have the Oracle Rdb CONTROL privilege to use the DELETE PROTECTION statement. Revoking a privilege takes effect after the users detaches and attaches to the database again. You must execute this statement in a read/write transaction. If there is no active transaction and you issue this statement, Oracle Rdb starts a read/write transaction implicitly. Other users are allowed to be attached to the database when you issue the DELETE PROTECTION statement.