Maintain History of Changes made to Palette user from Palette

A Rules Palette user having appropriate security management privileges in Rules Palette can create, modify, remove OIRP users, and make changes to their Security Role. The history of changes for OIRP Users done via Rules Palette is stored in AsHistory and AsHistoryDetail tables. To increase the performance of history tables, history related to various entities is being segregated to entity wise history tables. With this enhancement all the changes made to Palette user made via Palette will be moved to IVSUserHistory and IVSUserHistoryDetail tables and will be available for auditing purposes. For logging changes made to Palette user via Palette IVS should be ON and history will not get recorded if IVS is OFF.

  1. History for Palette user will get recorded when:

  2. A new user is added to OIRP.

  3. Existing user information is modified.

  4. Existing user's security role is modified.

  5. User is Deleted.

New tables to store Palette users' history are:

Table  Column Definition
IvsUserHistory USERHISTORYGUID This column stores the client historyguid. And will be the primary key.
  USERGUID This column stores the UserGuid. (IVSUSER)
  OPERATIONCODE This column stores code for the operation.
  CREATEDBY This column stores the USERNAME (IVSUSER) of the palette user who has done the modification.
  CREATEDGMT This column stores the created GMT.
  DETAILS This column stores the details
IVSUserHistoryDetail USERHISTORYGUID This column stores the client historyguid.
  FIELDNAME This column stores the field name like SecurityRole
  FROMDATA This column stores the old value.
  TODATA This column stores the new value.

Below codes are added to IVSCode table for Palette user history changes lookup:

Table CodeName Value Definition
ASIVSUserHistory PaletteUserHistoryOperation ADD This code will be used to reference the Add History Operation in IvsUserHistory
  PaletteUserHistoryOperation UPDATE This code will be used to reference the Update History Operation is IvsUserHistory
  PaletteUserHistoryOperation DELETE This code will be used to reference the Delete History Operation is IvsUserHistory

Upgrade Utility Updates

  • Creates new schema for OIRP history tables and creates the tables in IVS database.

  • AsCodeHistoryType for PaletteUserHistory will be deleted.

  • New codes for PaletteUserHistoryOperation will be created in IVSCode table.

  • If the customer has Palette history details in AsHistory and AsHistoryDetail tables scripts will be provided to migrate data from AsHistory and AsHistoryDetail table to IVSHistory and IVSHistoryDetail table.

  • Palette user history data will be deleted from AsHistory and AsHistoryDetail tables.

Column mapping for data migration from AsHistory to IVSHistory table and ASHistoryDetail and IVSHistoryDetail tables as below:

ASHistory Column Name IVSHistory Column Name
HistoryGUID UserHistoryGUID
RelatedGUID UserGUID
OperationCode OperationCode
UpdatedBy CreatedBy
UpdatedGMT CreatedGMT
Details Details

 

ASHistoryDetail Column Name IVSHistoryDetail Column Name
HistoryGUID UserHistoryGUID
FieldName FieldName
DataTypeCode DataTypeCode
FromData FromData
ToData ToData

Manual Configuration Updates

If the SQL in any of the existing business rule's configuration is using Palette user's historical data, the same must be manually updated to reflect the new tables IVSHistory and IVSHistoryDetail .

Maintain History of Changes made to Application User

Administration of OIPA Application users is done in Rules Palette. Rules Palette User with necessary security management privileges in Rules Palette can create, modify, remove and reactivate the OIPA Application users, and change their links to the Security Groups. The history of changes made to the Application users is recorded in AsHistory and AsHistoryDetail tables in OIPA. To increase the performance of history tables, history related to various entities is being segregated to entity wise history tables. With this enhancement all the changes made to Application users made through Palette will be moved to AsUserHistory and AsUserHistoryDetail tables and will be available for auditing purposes

The history of changes for OIPA Users gets recorded on

  • Adding a new OIPA user

  • Modifying information related to OIPA user

  • Adding a security group to the OIPA user

  • Deactivating security group from the OIPA user

  • Inactivate the OIPA user

  • Reactivate the OIPA user

Table Name Column Definition
ASUSERHISTORY USERHISTORYGUID This column stores the User historyguid, also it is the primary key
  CLIENTGUID This column stores the clientguid of the OIPA User for which the change was done.
  OPERATIONCODE This column stores code for the operation.
  CREATEDBY This column stores the USERNAME of the palette user who has done the modification.
  CREATEDGMT This column stores the createdgmt.
  DETAILS This column stores the details
ASUSERHISTORYDETAIL USERHISTORYGUID This column stores the client historyguid.
  FIELDNAME This column stores the fieldname.
  DATATYPECODE This column stores the datatypecode.
  SECURITYGROUPGUID This column stores the SecurityGroupGUID for a case when FROMDATA and TODATA are for a Security Group
  FROMDATA This column stores the old value.
  TODATA This column stores the new value.

Upgrade Utility Updates

  • Creates new schema for OIPA history tables and creates the tables in OIPA database.

  • AsCodeHistoryType for AppUserHistory and AppUserRoleHistory with values 28 and 29 will be deleted.

  • New codes for User history Operation will be created in ASCode table.

  • Migrates data from AsHistory and AsHistoryDetail table to AsUserHistory and AsUserHistoryDetail table.

  • Application user history data will be deleted from AsHistory and AsHistoryDetail tables.

Manual Configuration Updates

If the SQL's in any of the existing business rule's configuration is using Application user's historical data, the same must be manually updated to reflect the data from new tables AsUserHistory and AsUserHistoryDetail.