Kintana Script : Demand Request 'Make a Copy' Button

Purpose

A user may complain that he cannot copy a request.

The [Make a Copy] button only appears on a request if the user is in (any) one of the security groups listed on the request type's [User Access] tab that has the 'Create' rights checkbox ticked.

Tested

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

Usage

Paste the script into Toad or SQL Runner

select unique crt.request_type_name,
       crts.can_create_code,
       nsg.security_group_name
from KNTA_ACCESS_SECURITY nas,
     KNTA_SECURITY_GROUPS nsg,
     KNTA_ACCESS_GRANTS nag,
     KCRT_REQUEST_TYPE_SECURITY crts,
     KCRT_REQUEST_TYPES crt
where nas.security_group_id = nsg.security_group_id
  and nag.access_grant_id = nas.access_grant_id
  and nag.category = 'Demand Mgmt'
  and crts.security_group_id = nas.security_group_id
  and crt.request_type_id = crts.request_type_id
  and crts.can_create_code = 'UNCHECKED'
order by crt.request_type_name

select nu.first_name || nu.last_name "User",
       nsg.security_group_name
from KNTA_USER_SECURITY nus
     KNTA_USERS nu,
     KNTA_SECURITY_GROUPS nsg
where nus.user_id = nu.user_id,
  and nus.security_group_id = nsg.security_group_id
order by nsg.security_group_name, 1

Download

KintanaScripts.zip (58 Kb)