Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can I get logged in user name from within a stored procedure?
select user from dual;
Jeff
David Sisk wrote:
>
> 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 Mon Aug 30 1999 - 08:17:00 CDT