Create a TMS Administrator User Account

This section describes creating an administrator-level TMS user, which is defined as a user with the OPA_ADMIN role. Users with this role have access to the Define Users window in TMS, which enables them to create additional users in the database.

To create a new Oracle account for a user:

1. Connect to SQL*Plus as system and run the following script:

   <OPA_HOME>\tms\541\install\tmsadduser.sql

2. Enter a user ID.
3. Enter a password for this user. Do not use the identified externally clause; explicitly assign a password.
4. Grant the OPA_ADMIN role to the user:

   grant OPA_ADMIN to user_id