Alex Schonlinner wrote:
> The information we would like to use is osuser, machine and program from
> v$session, so our system can recognize who (i.e. what interface or human
> being) made the update.
>
> But as I said above, I'm personally anxious about retrieving that information
> from v$session.
> But I'm not sure why...it's only a feeling not to use such views for such
> jobs...
>
> But perhaps others have a much better experience with Oracle...
>
> Regards,
> Alex
check out sys_context, may be what you're after
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a85397/function.htm#88703
Received on Wed Feb 11 2004 - 11:53:37 CST
