Kintana Script : CLM V$ Database Grants

Purpose

Access to Oracle's'V$ Views is essential if you want to exercise close control over the database.

As a minimum you need to setup these access grants.

Tested

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

Usage

Paste the script into SQL Runner

grant select  on SYS.v_$parameter to clm;
grant execute on SYS.dbms_stats   to clm;
grant select  on SYS.v_$mystat    to clm;
grant select  on SYS.v_$process   to clm;
grant select  on SYS.v_$session   to clm;

Download

KintanaScripts.zip (58 Kb)