Re: v$session

From: Devinder Pal Singh <devinder.palsingh_at_pharma.novartis.com>
Date: Tue, 29 Dec 1998 11:28:09 -0500
Message-ID: <36890318.62BC172@pharma.novartis.com>

You cannot use the v$ tables/views in pl/sql as they are granted thru a role. The only thing you can do is to grant specific privileges on these tables. Dave

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
Received on Tue Dec 29 1998 - 10:28:09 CST