Salah satu contoh untuk membuat triggernya:
1. Connect sebagai SYSTEM:
CREATE OR REPLACE TRIGGER LOGON_TRIGGER
AFTER LOGON ON DATABASE
DECLARE
v_user_identifier varchar2(64);
BEGIN
SELECT SYS_CONTEXT('USERENV', 'OS_USER')
||':'||
SYS_CONTEXT('USERENV', 'IP_ADDRESS')
INTO v_user_identifier
FROM dual;
DBMS_SESSION.SET_IDENTIFIER(v_user_identifier);
END;
/
2. Connect sebagai SCOTT, untuk mencoba apakah trigger yang telah dibuat
berhasil dieksekusi.
3. Connect sebagai SYSTEM:
SELECT username, client_identifier, module FROM V$SESSION;
USERNAME CLIENT_IDENTIFIER MODULE
------------------------------ ------------------------------- --------------
SYSTEM indra:10.10.10.27 SQL*Plus
SCOTT indra:10.10.10.27 SQL*Plus
Selanjutnya bisa dimodifikasi sendiri sesuai dengan kebutuhan.
Semoga membantu.
Salam,
Indra Armansyah
[EMAIL PROTECTED]
----- Original Message -----
From: Oscar Wilyanto
To: [email protected]
Sent: Friday, March 16, 2007 7:55 AM
Subject: [indo-oracle] Dapetin IP address client di isqlplus
Dear Masters,
Saya ingin membuat trigger yang mencatat semua ip address yang melakukan
loggin ke database, terutama yang melalui isqlplus..
Bagaimana caranya? apakah ada paket khusus untuk ini?
Thanks in Advance
Oscar
----------------------------------------------------------
This message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately by e-mail if you have received this e-mail by mistake and delete
this e-mail from your system. E-mail transmission cannot be guaranteed to be
secure or error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. MKD Group therefore
does not accept liability for any errors or omissions in the contents of this
message, which arise as a result of e-mail transmission. If verification is
required please request a hard-copy version.
MKD Group, www.mkdgroup.com
----------------------------------------------------------
[Non-text portions of this message have been removed]
------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.11/722 - Release Date: 3/14/2007
3:38 PM
[Non-text portions of this message have been removed]
