272890

From CTMS

272890 - PA-7ZFDTF/ Allow Management of User Profiles

Copyright OBS Logistics © 2010

The information contained herein is the property of OBS Logistics and is supplied without liability for errors or omissions. No part may be reproduced or used except as authorised by contract or other written permission. The copyright and foregoing restriction on reproduction and use extend to all media in which the information may be embodied


FUNCTIONAL OVERVIEW

Client Requirement

Allow Profiles to be deleted with all associated parameters - controlled by Group Function parameter. Parameters set in User profile will take priority over User Parameters where they exist in both. E.g. Group Name in Order Creation to be populated from selected Profile where a user has more than 1.

Solution

Add a new button to Access Control User Maintenance screen, ‘Delete Profile’ which allows the deletion of profiles. A function will be created called ADM_Profile_Admin (allow the deletion of user profiles).

When the user selects the Delete Profile command button, code will check the user has access to the new function. If the user does not have access to the ADM_Profile_Admin function they will not be able to delete the profile.

Once the correct user access is confirmed, a script will run which will delete all elements of the profile in the correct order to ensure there are no referential integrity issues.

ADM_USER_PROFILE ADM_USER_PARAM

The profile deleted will be the profile that is currently selected in the Profile tab of the user maintenance screen. Once the profile has been successfully deleted, the profile field will be set to null.

The existing procedure GET_MULTIPLE_USER_PARAM currently identifies active profile parameters to be used when populating information like Group Name on an order. User parameters are only used if the parameter set up in the active profile or no active profile

Scope

This change will be applied to system version 10.5 on CONTST and once approved CONPRD.

Data

The new system function called ‘ADM_PROFILE_ADMIN’ will need to be setup for the appropriate user groups.

FUNCTIONAL DESCRIPTION

The user access control screen will be changed to allow the whole of the user profile to be deleted via a new button on the ‘User Profile’ page of the ‘Edit User’ subscreen.

The screens may be accessed as shown below:


272890 1.png

‘User Maintenance’:

272890 2.png

Edit’

272890 3.png

The new button will be called ‘Delete Profile’ and will be placed to the right of the existing button called ‘New Profile’.

The new button will only be active if a user profile type has been selected and there are records present to delete.

A new program unit function will be created called ‘ADM_PROFILE_ADMIN’ to be run via the new ‘Delete Profile’ button if the user has access to perform the deletion.

The user must belong to a user group that is authorised to use the new function for the deletion of the user profile to proceed.

272890 4.png


The existing validation will be included to ensure that a user parameter may not be deleted, if any of the parameters for the user profile may not be deleted then the deletion will be prevented and the user informed. This will prevent the deletion of a user parameter if it is required and it is the last one.

The data will be deleted from the tables for the profile selected in sequence to avoid integrity problems:

  1. ADM_USER_PROFILE
  2. ADM_USER_PARAM

All of the user parameters will be deleted for the user profile displayed for the user and the profile field will be set to null once the profile has been successfully deleted.

Once deleted the user profile cannot be used by the existing function ADM.GET_MULTIPLE_USER_PARAM to obtain an active profile and its parameters to populate default values for the parameter type.


REFERENCES

Ref No
Document Title & ID
Version
Date
1
EST 272890 PA-7ZFDTF Allow Management of User Profiles v1.0.doc
1.0
26/01/10


DOCUMENT HISTORY

Version
Date
Status
Reason
Initials
0.1
03/02/10
Draft
Initial version
PDR
1.0
04/02/10
Issue
Reviewed and Issued
MJC


AUTHORISED BY

Matt Crisford Development Manager
Peter Greer TMSCC MTS Product Manager