Re: whoami

From: <saropani_at_my-dejanews.com>
Date: Tue, 26 May 1998 07:15:24 GMT
Message-ID: <6kdq6f$p1t$1@nnrp1.dejanews.com>

In article <35655991.15EA4CC6_at_cressoft.com.pk>, Umar FArooq <umar.farooq_at_cressoft.com.pk> wrote:
>
> is there a command (or column of a view/table) in oracle equivalent to
> the 'whoami' unix command
>
> THx.
>
>

hi

The equivalent sql statement of whoami is

select osuser from v$session
where terminal = userenv('terminal

Thanks.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue May 26 1998 - 02:15:24 CDT