Kintana Script : Step Security Tabs With Individual User Names

Purpose

Naming users explicitly on workflow step security tabs is very bad practice.

Always and only use WSS: security groups.

This script will locate workflow steps with explicit user names.

Tested

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

Usage

Paste the script into Toad or SQL Runner

select ww.workflow_name, wws.sort_order "Step No", wws.step_name,
       wwss.security_type_code,
       --wwss.security_group_id,
       wwss.user_id,
       nu.first_name || ' ' || nu.last_name
from KWFL_WORKFLOW_STEPS wws,
     KWFL_WORKFLOWS ww,
     KWFL_WORKFLOW_STEP_SECURITY wwss,
     KNTA_USERS nu
where ww.workflow_id = wws.workflow_id
  and wwss.workflow_step_id = wws.workflow_step_id
  and ww.enabled_flag = 'Y'
  and wwss.security_type_code = 'USER'
  and nu.user_id = wwss.user_id
order by ww.workflow_name, wws.sort_order

Download

KintanaScripts.zip (64 Kb)