Kintana Script : Validations using explicit security group names

Purpose

SQL type validations that contain security group name strings will fail if the security group name is changed.

You can change the string in the validation but a better solution is to use the security group ID which will not change, and add a comment using the 'c' style comment convention with the current sg name string:
/* WSS: Release Approvers */

Tested

With HP PPM (Project and Portfolio Management) Kintana v6.0.

Usage

Paste the script into Toad or SQL Runner

-- List SQL validations with security group name strings

select nv.validation_name,
       nv.validation_sql
from KNTA_VALIDATIONS nv
where nv.validation_type_code = 'SQL'
and ( validation_sql like '%security_group_name%'
      or
      validation_sql like '%SECURITY_GROUP_NAME%' )
and nv.enabled_flag = 'Y'
order by nv.validation_name

-- List security group ID's for a given sg name

select nsg.security_group_id, nsg.security_group_name,
       nsg.enabled_flag
from KNTA_SECURITY_GROUPS nsg
where nsg.security_group_name like '%MySg%'

Download

KintanaScripts.zip (79 Kb)