Security Setup Required

To run any API package from a tool outside of Oracle LSH, such as SAS, SQL Developer, or SQL*Plus, your system administrator needs to do the following:

1. Set up an Oracle LSH database account linked to your LSH user account; see "Creating Database Accounts" in the Oracle Life Sciences Data Hub System Administrator's Guide.
2. Grant your Oracle LSH database account Execute privileges on the API security package CDR_PUB_API_INITIALIZATION.
3. To run APIs that insert, delete, or modify Oracle LSH classification hierarchy terms, you need security access to the Oracle Thesaurus Management System (TMS) instance that is installed as part of Oracle LSH. The Oracle LSH classification system is based on TMS.

   Note:

   This step is not required for Oracle DMW custom programs. DMW does not use the LSH classification system.

   Ask your system administrator to run the script tmsadduser.sql to do the following:

   • Create a TMS user account with the same name as your Oracle LSH database account so that your account is entered in the TMS_ACCOUNTS and OPA_ACCOUNTS tables.
   • Give your TMS user account superuser privileges in the TMS_ACCOUNTS table.
   • Grant your TMS user account the TMS_MAINTAIN_PRIV database role.