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.