Access v$session in a trigger failed
I tried to crearte a trigger to monitor user log on event. In this trigger body I have a 'select ... from v$session' statement. When I create this trigger under system schema, I got a warning: Triggger created with compilation errors. With 'show errros', I saw 'table or view doesn't exist'. when replacing v$session with dual, the trigger can be created without problem. Creating the trigger under sys, there is no errors.
So there must be somthing I'm missing about accessing v$session like views in the trigger body.
Appreciate your clarifying my confusions.
Click Here to Expand Forum to Full Width