Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: v$session
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