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 [2.04ms]