Secure Access to APIs

Oracle LSH includes a set of APIs that enable you to do most of the things you can do through the user interface, including creating, modifying, and installing objects. You can call Oracle LSH APIs from source code in a defined Program in Oracle LSH. In this case, no additional security or setup is required.

To run any API package from a tool outside of Oracle LSH, such as SAS, SQL Developer, or SQL*Plus, your system administrator must configure security settings including setting up a database account and a Oracle TMS account with specific privileges. In addition, you can use a PL/SQL wrapper or the security API functionality.

See the Oracle Life Sciences Warehouse API Guide.