Re: Webdb - capturing Login ID
Date: Tue, 15 Aug 2000 09:46:18 +0100
Message-ID: <8navjj$her$1_at_plutonium.btinternet.com>
[Quoted] 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
Received on Tue Aug 15 2000 - 10:46:18 CEST