Granting Select Privileges to v_$session
If you want OpenText PPM to keep track of the open database sessions it uses, make sure that a public grant exists on the v_$session dynamic performance table. To do this, connect as SYS to the database that contains the OpenText PPM database schema, and then issue the following SQL statement.
grant select on v_$session to public
Note: You typically assign this grant during OpenText PPM installation or upgrade.