Solution : https://service.sap.com/sap/support/notes/963760 (SAP Service marketplace login required)
Summary :
SAP Note addresses the ORA-20000 error indicating "Insufficient privileges" encountered when running update statistics in SAP BW 7.00 with SP07 or above. Adjusted BW statistics modules necessitate ensuring Oracle memories are flushed before updates. As a solution, necessary authorizations need extension either to the SAPCONN role for Oracle 10.2 and above, or the SAP<sid> or SAPR3 user for Oracle 10.1. Execute as SYSDBA to assign "analyze any" rights to the appropriate account, correcting the described problem with a forward-planning measure to include necessary permissions in future SAP releases.
Key words :
sap sap<sid> oder sapr3, future sap releases, sysdbasql> grant analyze, requires additional authorizations, terms update statistics, sapr3 user, analyze reason, required authorizations, update statistics, symptom ora-20000
Related Notes :
| 834917 | Oracle Database 10g: New database role SAPCONN |
| 633914 | Error when executing DBMS_STATS |