Re: Client user or Machine name ?

From: A. B. Normal <abnormal_at_scottsbrain.com>
Date: Fri, 01 Aug 2003 14:07:53 GMT
Message-ID: <c4f17f2caa143076012d43bbb8e3a9de@news.bubbanews.com>

"MARIO" <meisinger_at_div.com.hr> wrote in news:bgdi72$md0$1_at_ls219.htnet.hr:

> Hi
>
> How get MACHINE name or CLIENT USER , for auditing trigger.
>
> Example. for TERMINAL is
>
> select userenv('TERMINAL') into stroj from dual;
>
> how for MACHINE or CLIENT USER ???
>
> Thanks !!!
>
>
> Mario
>

SELECT machine,osuser
INTO m,u
FROM v$session
WHERE audsid = USERENV('SESSIONID');

The user owning the procedure will need SELECT privilege on sys.v_ $session Received on Fri Aug 01 2003 - 09:07:53 CDT