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 8 added 10 lines
!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
At line 9 removed one line
[{If var='loginstatus' contains 'authenticated'
At line 12 changed 4 lines
![Discussion|Edit:Internal.UMRS]
[{InsertPage page='Internal.UMRS' default='Click to create a new discussion page'}]
}]
![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