?Hello Seb. Just took a look at docs, they seem to be outdated a bit. Try following set of roles and privileges:
CREATE TABLE, CREATE SEQUENCE, CREATE PROCEDURE, CREATE TRIGGER, CREATE SESSION, UNLIMITED TABLESPACE? SELECT_CATALOG_ROLE? CONNECT, RESOURCE I understand that some of them overlaps, but this set was verified to work. IMO 1st 5 privileges can be dropped. -- Regards, Myroslav Papirkovskyi ________________________________ Від: [email protected] <[email protected]> Надіслано: 18 вересня 2015 р. 12:47 Кому: [email protected] Тема: Oracle DB privileges 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
