Details

    • Type: Task
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.0.3
    • Component/s: Analysis
    • Labels:
      None
    • 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')
      /

        Attachments

          Issue Links

            Activity

            Hide
            jjhanso 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
            jjhanso 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
            jjhanso Jeremy Hanson added a comment -

            sql updated in 2010-09-01.sql

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

              People

              • Assignee:
                jjhanso Jeremy Hanson
                Reporter:
                jkneal 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