Hi, I am currently trying to Upgrade HDP 2.2 to 2.3 which starts with upgrading Ambari to v2.1 beforehand. I am using an Oracle 11g database which seems to be pretty troublesome. The HDP docs state the following privileges:
GRANT create session to <AMBARIUSER>; GRANT create TABLE to <AMBARIUSER>; GRANT create SEQUENCE to <AMBARIUSER>; But (at least for the upgrade process) these are not sufficient. I needed to grant "drop any index" and "create any index" to the ambari db user and I'm still having some issues. Is there a complete list which privileges are really necessary for ambari to run/upgrade properly? I can't find anything in the docs. Thanks! - Seb
