To change an index with the CHANGE INDEX statement, you need the Oracle Rdb CHANGE privilege for the relation. 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 CHANGE INDEX statement.