Creating User in ORMS – Retail Merchandising System
User creation tested in RMS versions14.0 and 14.1Step 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
