How to setup security access to Oracle Retail Merchandising System(RMS)

Following steps will help on setting security access to Oracle Retail Merchandising System(RMS) Forms -

1. Create role in the database (table name - dba_roles) :

Command: ‘create role Tester’

2. To assign read,write privilileges (table name – role_sys_privs) :

Command: ‘grant insert any table,update any table,delete any table to Tester’

3. To assign just read only privileges (table name – role_sys_privs):

Command: ‘Grant create session, execute any procedure,execute any type,select any sequence,select any table to Tester’;

4. grant insert on rms12dev.NAV_USER_OPTIONS to Tester;

5. Assign this role to required users using (table name - dba_role_privs):

grant Tester to RMS12D;

6. Register new RMS Forms:

New folder Registration command:

INSERT INTO nav_folder VALUES ('RATE', 'Rate', NULL, 'RMS12D', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

‘Rate Form’ Registration Commands:

INSERT INTO nav_element VALUES ('xxrates', 'F', 'RMS') ; -- xxrates is exactly the .fmb name

INSERT INTO nav_element_mode VALUES ('xxrates', '--DEFAULT--', 'RATE', 'Rates setup', 'RMS12D', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO nav_element_mode_role VALUES ('xxrates', '--DEFAULT--', 'RATE', 'Tester');

COMMIT;

You can create new folder and element thru front end See red color highlighted boxes below.

7. From RMS front end tree administration, assign the required forms to the database roles.

· Perform below steps for Security and accessibility of the screens:

8. New role ‘Tester’ created above steps.

9. Give full permissions (View, edit and add) to this role for ‘Rate Form’..

Navigation:

i. Log into RMS System

ii. Select ‘Control’ left side menu. control -> System -> Tree Administration -> Double click on ‘Rate’ Folder-> Click on security (It will show you 2 forms left side) -> select the role ‘Tester’.

Double click on Rate folder:

Assign new role Developer along with Tester Role:

Note:- The above post can be viewed in PDF format in the documents section in the following link:
Setup Security in Oracle RMS