Create User in Oracle retail Merchandising - ORMS

Creating User in ORMS – Retail Merchandising System

User creation tested in RMS versions14.0 and 14.1

Step 1
Go to this path in Unix Box with login used to install RMS (Your path can be different)

User-id: oracle
Password: xxxyyy

Step 2
Login to sqlplus and go the scripts path as shown below:

$bash - cd /U02/rms/installer/create_db
$bash - sqlplus  / as sysdba

SQL>@create_user_generic.sql;

Enter Username:-rms01
Enter Password:-xyz
Enter temp Tablespace:- TEMP

Step3
Run the synonym script for the new user rms01 to access the objects of the schema user rms14dev in my case. Please use your schema user name.

SQL> @create_synonyms_one_user.sql;

Enter value for 1 – rms01
Enter value for 2 – rms14dev

Step 4
Connect with New User/Password:

SQL>conn rms01/xxxxxx

Run the below  script.
SQL>@englishUser.sql;


Step5
Run the Super User Script if required.

conn rms01/xxxxxx

Run the below  script.
SQL>@SuperUser.sql;


************************************Done**********************************

For complete installation Help and Support please drop mail with your requirement at below mentioned Email-ID

We can setup Oracle RMS environment along with Mom products for your learning with just some maintenance cost

info@orainstall.com