ORA-01031 when trying to ALTER INDEX REBUILD ONLINE
When you want user to be able to rebuild any index in a database, it is enough to grant him alter any index. It is NOT enough when user wants to rebuild index ONLINE – this is because journal table is created in schema where rebuilding index resizes. So those are privileges required to online rebuild index:
ALTER ANY INDEX
CREATE ANY INDEX
CREATE ANY TABLE
sdmrnv, 2018-12-02 [1.478ms, s]