Details

    • Type: Task Task
    • Status: Closed Closed
    • Priority: Critical Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.0.3
    • Component/s: Analysis
    • Labels:
      None
    • Similar issues:
      KULRICE-8322Apply database updates for messages to master data source
      KULRICE-4517Add new sample app table to master data source
      KULRICE-8349Insert guest KIM data in master data source
      KULRICE-4259rice routing rule delegation document type didn't end up in the rice kualie client master data source (is missing in test drive and the distribution)
      KULRICE-10102Update KIM permissions for edit document in master data source
      KULRICE-5680Add Sample App (bookstore) data to master db
      KULRICE-106add module to the system parameters and rules tables (was: add module and component to the system parameters and rules tables)
      KULRICE-2731Allow for BusinessObjectService to persist to more than one data source
      KULRICE-6630Add SQL scripts for missing data in master database
      KULRICE-5621Add KRMS doc types to master DB
    • Rice Module:
      KNS
    • Application Requirement:
      KFS
    • KAI Review Status:
      Not Required
    • KTI Review Status:
      Not Required

      Description

      To support configuration of sensitive data as warnings need to have a new system parameter added to the master data source.

      INSERT INTO `krns_parm_t` (`NMSPC_CD`,`PARM_DTL_TYP_CD`,`PARM_NM`,`OBJ_ID`,`VER_NBR`,`PARM_TYP_CD`,`TXT`,`PARM_DESC_TXT`,`CONS_CD`,`APPL_NMSPC_CD`)
      VALUES ('KR-NS', 'All', 'SENSITIVE_DATA_PATTERNS_WARNING_IND', 'e7d133f3-b5fe-11df-ad0a-d18f5709259f', 1, 'CONFG', 'N', 'If set to \'Y\' when sensitive data is found the user will be prompted to continue the action or cancel. If this is set to \'N\' the user will be presented with an error message and will not be allowed to continue with the action until the sensitive data is removed.', 'A', 'KUALI')
      /

        Issue Links

          Activity

          Hide
          Jeremy Hanson added a comment -

          Ran the following sql against rice103dba and ricekulcli103dba:

          INSERT INTO krns_parm_t(NMSPC_CD, PARM_DTL_TYP_CD, PARM_NM, OBJ_ID, VER_NBR, PARM_TYP_CD, TXT, PARM_DESC_TXT, CONS_CD, APPL_NMSPC_CD) VALUES ('KR-NS', 'All', 'SENSITIVE_DATA_PATTERNS_WARNING_IND', 'e7d133f3-b5fe-11df-ad0a-d18f5709259f', 1, 'CONFG', 'N', 'If set to ''Y'' when sensitive data is found the user will be prompted to continue the action or cancel. If this is set to ''N'' the user will be presented with an error message and will not be allowed to continue with the action until the sensitive data is removed.', 'A', 'KUALI')
          /

          Please add this sql to a file in the /scripts/upgrades/1.0.2 to 1.0.3/db-updates/2010-09-01.sql and commit this to the project.

          Show
          Jeremy Hanson added a comment - Ran the following sql against rice103dba and ricekulcli103dba: INSERT INTO krns_parm_t(NMSPC_CD, PARM_DTL_TYP_CD, PARM_NM, OBJ_ID, VER_NBR, PARM_TYP_CD, TXT, PARM_DESC_TXT, CONS_CD, APPL_NMSPC_CD) VALUES ('KR-NS', 'All', 'SENSITIVE_DATA_PATTERNS_WARNING_IND', 'e7d133f3-b5fe-11df-ad0a-d18f5709259f', 1, 'CONFG', 'N', 'If set to ''Y'' when sensitive data is found the user will be prompted to continue the action or cancel. If this is set to ''N'' the user will be presented with an error message and will not be allowed to continue with the action until the sensitive data is removed.', 'A', 'KUALI') / Please add this sql to a file in the /scripts/upgrades/1.0.2 to 1.0.3/db-updates/2010-09-01.sql and commit this to the project.
          Hide
          Jeremy Hanson added a comment -

          sql updated in 2010-09-01.sql

          Show
          Jeremy Hanson added a comment - sql updated in 2010-09-01.sql

            People

            • Assignee:
              Jeremy Hanson
              Reporter:
              Jerry Neal (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 30 minutes
                30m
                Remaining:
                Remaining Estimate - 30 minutes
                30m
                Logged:
                Time Spent - Not Specified
                Not Specified

                  Structure Helper Panel