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.
| 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
