Omega Technical Support

To Remove Dormant Logins from the Database

Log into SQL *PLUS as the OmegaPS database Owner (O2B/ PASSWORD)

Type the following at the SQL prompt:

SQL> DELETE FROM LDB_LOGINS;

SQL> COMMIT;

Creating a New User

1. Set the start-in directory for SQL*PLUS to \OMEGAPS\DBA
2. Log into SQL*PLUS as the database administrator (SYSTEM/PASSWORD) At the prompt do the following: SQL> @ NEWUSER Enter new user and new user's password. The user is now set up in the oracle database.
3. Now go to OmegaPS, log in as the OmegaPS database owner (O2B/PASSWORD).
4. Go to FILE>SECURITY then FILE>USERS. Add the user just entered and a description for the user.
5. Save & exit.
6. Go to FILE>TEAMS. Add the user to the required team.
7. Save & exit.

Back to Frequently Asked Questions