Re: Can I get logged in user name from within a stored procedure?

From: David Sisk <davesisk_at_ipass.net>
Date: Sun, 29 Aug 1999 21:03:09 -0400
Message-ID: <Kzky3.1259$tp2.1271@news.ipass.net>

I believe "SELECT username FROM user_users" will give you what you need.

Regards,

--
David C. Sisk
Need tech info on Oracle? Visit The Unofficial ORACLE on NT site at http://www.ipass.net/~davesisk/oont.htm Like original music? Listen to song samples and buy a CD at http://www.mp3.com/disparityofcult

Jonathan Gennick wrote in message
<37c958b8.1084779_at_netnews.worldnet.att.net>...
>Does anyone know a good way to get the name of the currently
>logged in user from within a stored procedure? The USER
>function always returns the name of the procedure's creator.
>Is there a way around this? I'm using Oracle8, not 8i.
>
>Jonathan
>
>_____________________________________________________
>jonathan_at_gennick.com
>http://gennick.com
>Brighten the Corner Where You Are
>
Received on Sun Aug 29 1999 - 20:03:09 CDT