Re: v$session

In article <76a7l2$86u$1_at_nnrp1.dejanews.com>,   cap.flint_at_usa.net wrote:
> hi sabios
>
> i want to write a trigger that updates some dba audit-actions tables.
> my question is: how can i insert the machine value from v$session into those
> audit tables?, is possible to select v$session from pl/sql trigger?
>
> thnks in advance
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

You need to have "select any table" privilege granted directly to user (not to a role like DBA) in order to read V$ tables.

--
Mladen Gogala

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own