Setting Up TMS Security for Users

Users who will run Oracle Life Sciences Data Hub APIs that insert, delete, or modify Oracle LSHclassification hierarchies and terms (LSH Classification Admin tasks) need security access for their Oracle LSH database account to the Oracle Thesaurus Management System (TMS) instance that is installed as part of Oracle LSH.

Use the script tmsadduser.sql to add users to the TMS_ACCOUNTS and OPA_ACCOUNTS tables with TMS superuser privileges:

1. Open a command window on the TMS Middle tier server.
2. Set local=database
3. Change directory to the install directory of the TMS 4.6 installation.
4. Log on to your LSH database in SQL*Plus as the system account.
5. Run the script to add TMS superusers:

   start tmsadduser

6. The system prompts you for the following information:
   • User ID. Enter the user's LSH database account ID.
   • User Password. Enter the user's LSH database account password.
   • First Name. Enter the user's given name.
   • Last Name. Enter the user's family name.
   • TMS Password. Use the password you entered in when you installed the TMS database; see "Installing Oracle Thesaurus Management System" in the Oracle Life Sciences Data Hub Installation Guide.
7. Repeat Step 3 for each user.