Granting Security Access to APIs

In order to run any of the public APIs for Oracle Life Sciences Data Hub from outside Oracle LSH, a user must have the Execute privilege granted on the API package cdr_pub_api_initialization.

To grant this privilege to a user, do the following:

  1. Log in to SQL*Plus on the Oracle LSH database.
  2. Enter:

    Grant execute on cdr_pub_api_initialization to user_name;