some problem about cartridge5.2

Hi, everybody

I have installed cartridge 5.2 on existing database, and i use "jchem" schema for cartridge owner, then i hope  another existing user "acd3d20083" has the access JChem Cartridge functionality privileges, but there is some problem in my steps.

1. use "acd3d20083" login PL/SQL.

2. excute dbms_java.grant_permission.

3. excute privman_pkg.grants_on_jcobjs(fail here).

   call privman_pkg.grants_on_jcobjs('ACD3D20083', 'JCC_BASIC_ROLE');

Could you tell me the true detail step?

thanks in advance.

Hi,

 

1. use "acd3d20083" login PL/SQL

This user cannot grant himself privileges (of course).

You have to be logged in as the the JChem-owner ("jchem") and you need SYSTEM privileges for some of the steps that are described in detail here: 

http://www.chemaxon.com/jchem/doc/admin/cartridge.html#admin_tasks 

 

Best regards,

 

Szilard