ezds.com : Kintana Script : Application Codes by Security Group.

Kintana Script : Application Codes by Security Group

ZDS

Kintana Scripts

Purpose

If you can't find an application code in the pick list when creating a request line and you know that the code is defined, this could be due to one of two reasons:

The application Code is not defined in EVERY environment referenced by the Workflow.

You belong to a security group which is restricted from using the application code.

This script will help you identify the SECOND reason : security groups which deny the use of a given application code.

Tested

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

Usage

Paste the following script into SQL Runner

Change the 'restriction_type = 'MY_APP_CODE' to the application code you want to check.

Omit the comment unless you're using a PL-SQL editor.
SQL Runner only supports select statements and you'll get a KNTA-10648 error.

Script

-- List Application codes by Security Group

select ner.entity_restriction_id,
       ner.restriction_type,
       ner.parent_value,
       ner.child_value,
       nsg.security_group_name
from KNTA_ENTITY_RESTRICTIONS ner,
     KNTA_SECURITY_GROUPS nsg

where restriction_type = 'MY_APP_CODE'

and ner.parent_value = nsg.security_group_id
order by ner.parent_value, ner.child_value

Output

ENTITY_RESTRICTION_ID RESTRICTION_TYPE PARENT_VALUE CHILD_VALUE SECURITY_GROUP_NAME
--------------------- ---------------- ------------ ----------- --------------------
35091                 MY_APP           20015        QPR         Developers
35092                 MY_APP           30047        PMG         Product Management
35093                 MY_APP           30234        QA          Quality Assurance
35094                 MY_APP           30234        QAAS        Quality Assurance
35100                 MY_APP           30234        QADP        Quality Assurance

If you see any security groups listed they will all restrict (deny) the use of this application code.

You will need to check which security groups the user belongs to.

Note that the user ( who may be you), need only belong to ONE security group that allows (does not restrict) the application code for it to be available.

For more detail see the App Codes section in the System Administration Guide.

To extract the output, click on the [Open as Text] button.

This opens a text window from which you can copy and paste the output.

Download

KintanaScripts.zip (58 Kb)