"That's fine but I have a separate database user and password the application server is configured with, I don't use that to login with. I thought it would pick that up from the appserver settings."
-> yes, it is using the db user specified in the blasadmin settings. does that user have the listed permissions?
I had already checked the permissions with my dba team prior to attempting the upgrade. I will get them to send me a full list to compare myself.
Thanks for clarifying which user it is using though.
EXECUTE ON SYS.DBMS_SQL was missing. Is this only required during the upgrade and can be revoked again afterwards without affecting functionality in any way?
GRANT EXECUTE ON DBMS_SQL TO BLADELOGIC Upgrade process
The call creates triggers on one of the underlying tables.
Once the triggers are created (as part of upgrade/migration), the permission can be revoked.
You can grant the privilege before upgrade and then revoke after upgrade.