Kintana Script : Access Grants

Purpose

Access to Kintana system functionality is controlled by access grants.

This script lists the grants available on your system.

Tested

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

Usage

Paste the script into Toad or SQL Runner

-- Access grants available for the system

select nag.category,
       nag.access_grant_name
from KNTA_ACCESS_GRANTS nag,
order by nag.access_grant_name

-- User grants via security groups

select nu.full_name,
       np.product_name,
       nsg.security_group_name,
       nas.access_grant_id,
       nag.category,
       nag.access_grant_name
from KNTA_ACCESS_SECURITY nas,
     KNTA_ACCESS_GRANTS nag,
     KNTA_SECURITY_GROUPS nsg,
     KNTA_USER_SECURITY nus,
     KNTA_USERS nu,
     KNTA_USER_PRODUCTS nup,
     KNTA_PRODUCTS np
where nag.access_grant_id = nas.access_grant_id
  and nas.security_group_id = nsg.security_group_id
  and nas.security_group_id = nus.security_group_id
  and nus.user_id = nu.user_id
  and nag.category = 'Config'
  and nag.access_grant_name like 'Edit%'
  and np.product_id = nup.product_id

Download

KintanaScripts.zip (58 Kb)