jc_updateb has no synonym nor grants

JCHEM_CORE_PKG.GETENVIRONMENT()


------------------------------------------------------------


Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production


PL/SQL Release 9.2.0.6.0 - Production


CORE 9.2.0.6.0 Production


TNS for Solaris: Version 9.2.0.6.0 - Production


NLSRTL Version 9.2.0.6.0 - Production


NLSRTL Version 9.2.0.6.0 - Production


JChem version in the database: 3.1.4


JChem version in the Tomcat server: 3.1.4


java.vm.version: 1.4.2_10-b03


java.vm.vendor: Sun Microsystems Inc.


Apache Tomcat/5.5.12





JCHEM_CORE_PKG.GETENVIRONMENT()


------------------------------------------------------------


Major JDBC version in Tomcat: 1


Minor JDBC version in Tomcat: 0





I've run the script for granting access to a user, but


the script does not grant any rights on the procedures that are


available in the owner of the cartridge nor synonyms for those.





How am I supposed to use the jc_updateb and jc_delete


if those are not granted ?





Regards,


Mikael

Mikael,





I guess you are referring to the script install_user.sh. The object type "procedure" has been inadvertently left out of the script. I attached a corrected version of the script. Sorry.





Peter