Kintana Script : User Database Privileges

Purpose

Use this to review access grants for security purposes or to check the rights you have.

Tested

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

Usage

Paste the script into Toad

select * from user_privs

select *
from sys.dba_role_privs
where GRANTEE like '%';

select * from sys.dba_sys_privs
where GRANTEE like '%';

select * from sys.dba_tab_privs
where GRANTEE like '%';

select username,
program,
sid,
serial#
from   v$session;

Download

KintanaScripts.zip (79 Kb)