This page (revision-4) was last changed on 09-Dec-2021 08:57 by Kevin Higgs

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
4 09-Dec-2021 08:57 1 KB Kevin Higgs to previous
3 26-Nov-2021 10:22 1 KB RForbes to previous | to last
2 26-Nov-2021 10:22 498 bytes JMyers to previous | to last
1 26-Nov-2021 10:22 303 bytes JMyers to last

Page References

Incoming links Outgoing links
UMRS
UMRS

Version management

Difference between version and

At line 3 changed one line
The Reconcile Security (UMRS) form is used to...
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.
At line 5 changed 2 lines
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
%%label-danger 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|DEFAULT_ROLE], as specified
----
![Notes|Edit:Internal.UMRS]
[{InsertPage page='Internal.UMRS' default='Click to create a new notes page'}]
This page (revision-4) was last changed on 09-Dec-2021 08:57 by Kevin HiggsTop