Main Region

FOEX 010204 upgrade
1 answer | 208 views

AW
Sep 26, 2014 12:56 +00:00

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

0 comments

MN
Sep 26, 2014 15:51 +00:00

Thanks for the feedback Alan, and our apologies for any heartache caused. We're going to update the documentation for the next release.

0 comments

You must log in or sign up to post questions and answers.