Kintana Script : Users Security Groups

Purpose

A simple script to list a user's security groups.

Tested

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

Usage

Paste the script into SQL Runner

Omit the comment, spool, and linesize statements unless you're using a PL-SQL editor. SQL Runner only supports select statements and you'll get a KNTA-10648 error. If using PL-SQL change 'yyyymmdd' in the output file name to today's date.

-- List User's Security Groups
spool c:\users_security_groups_yyyymmdd.txt
set linesize 1000

select nu.username,
       nu.full_name,
       -- nu.email_address,
       nsg.security_group_name
       --, nsg.description
from KNTA_USERS nu,
     KNTA_USER_SECURITY nus,
     KNTA_SECURITY_GROUPS nsg
where nu.user_id = nus.user_id
  and nus.security_group_id = nsg.security_group_id
  -- limit to a specific user
  and nu.first_name = 'Dave' and nu.last_name = 'Goodall'
order by nsg.security_group_name
 

spool off

USERNAME        FULL_NAME      SECURITY_GROUP_NAME
dgoodall        Dave Goodall   Inspection NOD
dgoodall        Dave Goodall   Stock Managers
dgoodall        Dave Goodall   Audit Control
...

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

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

Download

KintanaScripts.zip (79 Kb)