Hi all.
I'm facing the following problem during installation of orchestrator:
The internal procedures of a company I'm installing CIAC 3.1.1 at do not allow me to grant public access to all the objects I need to make the orchestrator service run. I'm using a dedicated Oracle database and the db admin revoked public access to the object DBMS_LOB (as an internal procedure, they always revoke public access to this and other objects, even if this is a dedicated database).
The user I created for installing orchestrator is called oradba. Even if the administrator grants oradba access to DBMS_LOB, I still have a problem with it:
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored ---> Devart.Data.Oracle.OracleException: ORA-06550: line 1, column 14:
PLS-00201: identifier 'DBMS_LOB' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
.
.
.
(a java stack trace follows)
So: is there any other user I must grant access to this object ? I tried granting access to public (which is not allowed due to the company's rules) and it works. Granting access to oradba only does not work. Is that enough to conclude that we have to grant access to some other user ? Any hints on which user that would be ?
Thanks for your support
