wish you would use full words, makes your posts really hard to read.

Anyway, you need access to v$session directly, not through a role - grant it to yourself

You do realise that your trigger doesnt actually do anything dont you - it just selects the information?