!!!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|DEFAULT_ROLE], as specified


----
![Notes|Edit:Internal.UMRS] 	
[{InsertPage page='Internal.UMRS' default='Click to create a new notes page'}]