RECONCILE SECURITY#

The Reconcile Security (UMRS) form is used to reconcile the data base access model found in IMUS (Users), IMRO (Roles) and IMUR (User-Role relationships). This function should only be executed when you have imported a data base structure (P2K schema only) into a new data base that has a completely different data base access model.

UMRS cannot be run to reconcile new security set up if using "Java Version SHA-1". If it is launched all user passwords will need to be reset.

Report Parameters
Trace Level	Optional, LOV Available When performing a trial calculation, you may specify the level of message that the calculation report should display. This field is used for troubleshooting purposes

Processing#

1) Create or update all users in the data base to match settings found in IMUS

a) Creates users with the same default tablespace,temporary tablespace and database profile as the user who is running the program

b) Users are created/altered to match the password

c) Users are granted the minimum requirements: CONNECT, Execute on selected security functions, Select on the P2K_AM_ROLES table

2) Create or update all roles within the data base to match settings found in IMRO

a) Roles are created/altered to match the password, if defined.

3) Grant roles defined in IMUR to the users who do not have these roles, following the settings for Default Role, as specified

---

Notes #