jawabnya seadanya, krn saya lupa cara2nya
1. di non-dynamic parameter, parameter AUDIT_TRAIL nya set dulu, di set tempat
untuk menyimpan peng-auditan
tempat :
a) OS : disimpan di OS audit trail
b) DB : disimpan di database
c) NONE : disable collection of audit records gitu deh
terus sama si yang punya hak buat ngeauditnya, ketik gini
AUDIT session WHENEVER {successful | not scuccessful}
biasa sih pake yang AUDIT SESSION WHENEVER NOT SUCCESSFUL;
biar ketahuan siapa yang gagal login
terus gampangnya gini deh, bapak ketik :
DESC DBA_AUDIT_SESSION, pilih kolom2 mana yang mo ditampilin
SELECT deh dari DBA_AUDIT_SESSION
misal -Kalo ga salah ada kolom host deh- :
SELECT host FROM DBA_AUDIT_SESSION;
maaf banget kalo jawabanny ga memuaskan,
senior2 oracle silahkan di perbaiki / dilengkapi
Oscar Wilyanto <[EMAIL PROTECTED]> wrote: 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 need to miss a message. Get email on-the-go
with Yahoo! Mail for Mobile. Get started.
[Non-text portions of this message have been removed]
