Anda bisa pake database trigger
CREATE OR REPLACE TRIGGER trig_log_user
AFTER LOGON ON DATABASE
WHEN (USER = 'HR')
DECLARE
v_hr VARCHAR2 (20);
BEGIN
SELECT TO_CHAR (SYSDATE, 'HH24')
INTO v_hr
FROM DUAL;
--after 10AM,does not allow connection.
IF v_hr >= 10
THEN
raise_application_error (-20001, 'go home');
END IF;
END;
/
On 10/03/2008, Yusuf <[EMAIL PROTECTED]> wrote:
>
> DH,
> Mohon pencerahan Senior2. Maaf, jika sudah pernah dibahas dimilis.
> Apakah ada tools (contoh Prosedur) di Oracle untuk membatasi user2
> login diluar jam kantor ? kecuali user2 tertentu yg lembur, itu pun
> dijadwal oleh DBA.
>
> TIA
> MYusuf
>
>
>
[Non-text portions of this message have been removed]
