When trying to upgrade the AE Database Oracle to version 21.0.4 or superior with DBload, the scripts fails due to missing trigger privileges.
U00038042 CREATE OR REPLACE trigger TR_AH_TIMESTAMP2_4
...
U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR ', '', 'ORA-01031: insufficient privileges'
Release : 21.0.4 and superior
Component : AUTOMATION ENGINE
Database: Oracle
Newly required permission on 21.0.4 or superior for Oracle Databases
Add the necessary "grant create trigger" to the Automic DB user before attempting to upgrade to 21.0.4 or superior.
This is now documented here and here
The script check_privileges.sql has also been upgraded to check this permission on 21.0.4 and superior so the command dbload checks this permission before attempting the procedure.