Hi Matt / Peter
I'm trying to install 010204 as a non SYS/SYSDBA user, using the privs which are specified in the install guide. I've come across a number of issues with this (one of which I've already raised around v$_tablespaces etc). the other issues are
The user needs to be granted:
CONNECT with ADMIN OPTION
CREATE PUBLIC SYNONYM with ADMIN OPTION
Execute on SYS.UTL_HTP is required by the FOEX_010204 user, but this (according to out DBA) can only be granted by SYS, so the point of using a non SYS/SYSDBA user for the install becomes a little pointless.
Alan