Why do I get errors during substance management actions for roles other than INV_ADMIN and INV_REGISTRAR?

Created
October 08, 2021 23:01

Date Posted: 2004-02-20
Product: ChemBioOffice Enterprise

Problem:

Solution:

There are missing grants to the CS_SECURITY user that cause missing grants to roles that are assigned the INV_MANAGE_SUBSTANCES privilege. To fix this issues:

Connect as:
cheminvdb2/oracle

Execute the following grants:

    GRANT EXECUTE ON GETCOMPOUNDID TO CS_SECURITY WITH GRANT
    OPTION;
    GRANT EXECUTE ON ISDUPLICATECOMPOUND TO CS_SECURITY WITH
    GRANT OPTION;
    GRANT EXECUTE ON SUBSTANCENAMEEXISTS TO CS_SECURITY WITH
    GRANT OPTION;

Use the Manage Roles Interface to reassign the INV_MANAGE_SUBSTANCES privilege to all Roles that require it.