Without the error(s) it is difficult to tell what can be the problem.

Probably privilege SELECT ON V_$SESSION is granted to the owner of the trigger trough a role and not directly to the user.
Try granting SELECT ON V_$SESSION, as SYS, to the owner of the trigger.