SELECT username FROM v$session;

hth,
AH

suarto Wijaya wrote:
>
> Dear all
>
> Kalau utk memgetahui user2 yg login ke database, bagaimana yach syntax
> querynya ?
>
> thx
>
> suarto
>
> _____
>
> From: [email protected] 
> <mailto:indo-oracle%40yahoogroups.com> 
> [mailto:[email protected] 
> <mailto:indo-oracle%40yahoogroups.com>] On
> Behalf Of awal_oshkosh
> Sent: Tuesday, August 28, 2007 08:05
> To: [email protected] <mailto:indo-oracle%40yahoogroups.com>
> Subject: [indo-oracle] Re: Baca Ip Addres
>
> Pake statement:
> SELECT SYS_CONTEXT(-'USERENV'-, 'IP_ADDRESS'-) FROM DUAL;
>
> hth,
> AH
>
> --- In HYPERLINK
> "mailto:indo-oracle%40yahoogroups.com"[EMAIL PROTECTED], "Mega
> Pramudya" <[EMAIL PROTECTED]>
> wrote:
> >
> > Dear all Master Oracle...
> > saya ada masalah sedikit ama oracle form...
> > bagai mana oracle form membaca ip komputer sendiri...
> >
> >
> > THX
> >
> >
> > Mega Pramudya
> >
> >
> >
> ----------------------------------------------------------
> > Pengen Coba Music Mail GRATIS? Aktifkan Music Mail anda di mail
> Telkom.net dan Plasa.com
> > dan kirim email dengan Music Mail ke seluruh rekan anda. Berlaku
> hingga 31 Agustus 2007.
> >
> ----------------------------------------------------------
> >
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.392 / Virus Database: 268.5.1/971 - Release Date: 24-Aug-07
>
> -- 
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.392 / Virus Database: 268.5.1/971 - Release Date: 24-Aug-07
>
>
> [Non-text portions of this message have been removed]
>
>  

Kirim email ke