Re: v$session

From: <mgogala_at_rocketmail.com>
Date: Tue, 29 Dec 1998 18:19:56 GMT
Message-ID: <76b6gb$105$1@nnrp1.dejanews.com>

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 Received on Tue Dec 29 1998 - 12:19:56 CST