Re: Webdb - capturing Login ID
Date: Wed, 16 Aug 2000 13:32:44 GMT
Message-ID: <8ne55r$m8q$1_at_nnrp1.deja.com>
In article <8navjj$her$1_at_plutonium.btinternet.com>,
"Philip Radford" <philipradford_at_bigfoot.com> wrote:
> Robert Garcia <Robert.Garcia_at_fm.ucsb.edu> wrote in message
> news:39985ADE.6E9A0AB3_at_fm.ucsb.edu...
> > I'm trying to capture the login id in webdb. Anyone know how to do
this
> > or can point me in the right direction.
> >
> > On another, but parallel thread, there seems to be a lack of real
> > documentation on this program (WebDb). Anyone know if Oracle is
going
> > to rectify this, or are we basically on our own?
> >
> > TIA
> > Bob Garcia, Associate Director
> > Facilities Management Information Systems
> > University of California, Santa Barbara
> >
>
> Bob,
>
> If you mean the UserID of the user logging in. Then simply do a
PL/SQL query
> as follows :-
>
> SELECT UPPER(USER)
> FROM DUAL;
>
> Philip Radford
> TGDA, UK
> philipradford_at_bigfoot.com
>
>
c_user := owa_util.get_cgi_env('REMOTE_USER');
htp.p( c_user );
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Aug 16 2000 - 15:32:44 CEST