Coba pakai query ini :
SELECT SYS_CONTEXT('USERENV', 'OS_USER') ||':'||
SYS_CONTEXT('USERENV', 'IP_ADDRESS')
FROM dual;
Semoga membantu
Alamsyah
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED]
On Behalf Of ghifari
Sent: 27 September 2005 13:29
To: [email protected]
Subject: [indo-oracle] tanya IP address yang akses database
Salam semuanya,
mau tanya nih, kalo kita sebagai DBA, terus bisa ga' kita tahu IP adress
siapa yang update atau insert suatu tabel pada user terntu berikut
waktunya.ada ga' ya data dictionarynya
terima kasih
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/PhFolB/TM
--------------------------------------------------------------------~->
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
