Wa'alaikumussalam Warahmatullohi Wabarokatuh ...
Hi Martin, apa kabar ?
Mungkin aku bisa kasih alternatif lain, utk tracing siapa, kapan dan
dari server mana dia logon (if account locked)
CREATE OR REPLACE TRIGGER logon_failures
AFTER SERVERERROR
ON DATABASE
BEGIN
IF (IS_SERVERERROR(28000)) THEN -- ORA-28000 account locked
INSERT INTO system.connection_audit
(login_date, username, ip_address)
VALUES
(SYSDATE, SYS_CONTEXT('USERENV','SESSION_USER'), SYS_CONTEXT
('USERENV','IP_ADDRESS'));
END IF;
END logon_failures;
/
Hasil test
SQL> conn scott/[EMAIL PROTECTED]
ERROR:
ORA-28000: the account is locked
Warning: You are no longer connected to ORACLE.
SQL> conn system/oracle
Connected.
SQL> select * from system.connection_audit;
LOGIN_DAT USERNAME IP_ADDRESS
--------- ------------------------------ ----------------------------
--
19-DEC-05 SCOTT 138.2.149.215
Bowo
--- In [email protected], "martin eran" <[EMAIL PROTECTED]>
wrote:
>
> Assalamu'alaykum Wa rahmatullahi Wa barakaatuh,
>
> saya ada sedikit pertanyaan yg kelihatannya mudah,
> saya menggunakan Oracle DB 10g, dan saya punya profile yg akan me-
lock
> account user apabila ia melakukan kesalahan login sebanyak 3x,
> yang saya perlu tahu adalah dari mesin mana account tsb terkunci?
> adakah semacam table yg berisi history penguncian suatu account
misal
> (bayangan saya spt) : V$ACCOUNT_LOCK_HISTORY ... ?
>
> NB : kalau jam brapa account tsb terkunci saya bisa lihat di tbl
DBA_USERS
> -> field LOCK_DATE
>
>
> Wassalamu'alaykum wa rahmatullahi wa barakaatuh,
>
> Martin Eran
>
> Contact :
> PT. Sompo Japan Insurance Indonesia
> MidPlaza I 18th Floor
> Jl.Jend. Sudirman Kav. 10-11 Jakarta 10220
> Mail : [EMAIL PROTECTED]
> [EMAIL PROTECTED]
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/2jUsvC/tzNLAA/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/
