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

Change the 'clm' as required to match your schema name

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 (64 Kb)